Write short note on Indexing .

-

 Indexing 

 Indexing is used to optimize the performance of a database by minimizing the number of disk accesses required when a query is processed. The index is a type of structure having only two columns. The first column comprises a copy of the primary or candidate Key of a table. The Second Column contains a set of pointers for holding the address of the disk block where Specific key values are stored.

Advantages of indexing

  •  Better performance of queries.
  • Fast Searching from the database.
  • Fast retrieval of data 
  • Increase performance in SELECT query.

Disadvantages of indexing

  • Indexing takes more space.
  • Decrease performance in INSERT, DELETE, and UPDATE query.
Figure: Structure of index











Comments

Post a Comment

Popular posts from this blog

Explain the architecture of data mining system with block diagram./Describe the Data Mining Architecture with figure.

-
Image
Data Mining Architecture The process of extracting information to identify patterns, trends, and useful data that would allow the business to take the data-driven decision from huge sets of data is called Data Mining. The data mining process involves several components, and these components constitute a data mining system architecture. The significant components of data mining systems are a data source, data mining engine, data warehouse server, the pattern evaluation module, graphical user interface, and knowledge base. The major component of a data mining system architecture is as follows:- Database, Data Warehouse, or Other Information Repository:  This is one or a set of databases, data warehouses, spreadsheets, or other kinds of information repositories. Data cleaning and data integration techniques may be performed on the data. Database or Data Warehouse Server: It fetches the data as per the users’ requirement which one needs for data mining task. Knowledge Base:  ...
Read more

Explain Quality of Service (QoS) Issue In Cloud in detail.

-
Image
 Quality of Service (QoS) Issue In Cloud  In recent years, corporate applications have been implemented in the cloud environment. And with such development, Quality of Service (QoS) management is one of the issues posed by cloud applications. This issue deals with assigning resources to mobile apps or web applications to provide a high quality of service increasing performance and accessibility. The degree to which a collection of fundamental characteristics meets the requirements. Fundamental characteristics are required components of the system and cannot be removed from it. A system's or application's quality is influenced by a variety of things such as Flexibility, Maintainability, Performance and Efficiency, Scalability, Availability, Reliability, Usability and Accessibility, Platform Compatibility, and Security. 1 Flexibility refers to the system's capacity to control functionality without harming the system. The services can be altered according to the business needs...
Read more

Computer Fundamental of TU IT Assistant

-
Image
Computer A computer is an electronic device that processes data and performs tasks according to a set of instructions called a program. It is a versatile tool that has become an integral part of modern life. Computers can handle a wide range of tasks, from simple calculations to complex simulations, and they are used in various fields such as education, business, healthcare, entertainment, and research. Characteristics of Computers: 1. Speed: Computers can perform tasks much faster than humans. They can execute millions of instructions per second. 2. Accuracy: Computers provide high levels of accuracy in calculations and data processing, reducing the chances of errors compared to manual methods. 3. Storage: Computers can store large amounts of data in digital format, allowing for easy retrieval and efficient management of information 4. Automation: Computers can perform repetitive tasks automatically, freeing humans to focus on more complex and creative activities. 5. Versatility: Comp...
Read more