Why it is necessary to establish table indexes in databases?
On One Hand: Speed Up Table OperationsTable indexes speed up table operations significantly so you can quarry data quickly, according to Mary Hooke, president of Distinctive Development and author of “Maximize Performance With Indexes.” Without indexes querying data from a data base would be a slow process. Table indexes work like an index from a book. If you are reading a book about the Civil War and want to find references to Abraham Lincoln, you look up Abraham Lincoln in the index and then go to the pages listed in the index rather than scan every page in the book looking for the words Abraham Lincoln.On the Other: Balance of Indexing NeededWhile indexing speeds up table operations (queries) it will slow down inserts and updates and take up disk space, according to Chris Smith, author of “An Introduction to Databases.” For a large database this becomes an issue for performance as well as backup and replication. Part of mastering indexing is finding the right balance between no inde
