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

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

What is meant by task environment? Explain the components of task environment?

-
Image
 The task environment consists of outside forces that are immediately relevant for the achievement of the goals of business organizations. It is composed of factors that are directly related to the competitive position of a business. It consists of different stakeholders who have a direct or indirect interests in the performance of the business. Stakeholders' support and response play important roles in the growth and development of a business A business can influence the stakeholders through effective strategy. To some extent, the task environment can be controlled by businesses. The components/elements of the task environment are discussed below. 1. Customer:  The customer is the most important component of the task environment. All business activities are directed toward satisfying customer needs and retaining them effectively. Customers may be an individual, families, or businesses. Besides purchasing goods and services, they are also the source of information and ideas ...
Read more

How the features like ubiquity, information density, and richness make e-commerce better than traditional commerce. Justify with examples

-
Image
There are four major characteristics of e-commerce: i. Ubiquity ii. Global Reach iii. Information Richness iv. Information density v. Personalization and Customization vi. Interactivity i. Ubiquity: Because E-Commerce is ubiquitous, the market is able to extend its traditional operating hours. Online stores never close, it is available everywhere at any time. Ubiquity lowers transaction costs for the consumer/buyer. For example, if the user is at an outstation, he also can through www.acer.com get information about the product. ii. Information Richness: Advertising and branding are important parts of commerce. E-Commerce can deliver video, audio, animation, etc. to introduce products. Individuals may see information richness if a post contains a video related to a product and hyperlinks that allow him/her to look at or purchase the product and send information about the post via text message or email. An example is the richness is can make the websites become attract people to browse. ...
Read more