24 Apr 2013

How does indexing improve query performance ?


ANS : It is a technique to physically organize the records to enable frequently used queries to run faster. Anything,  Updated ,deleted,re-done has to be updated in the table of indexes.
  This helps the process to run faster the nexttime you operate. And indexes cannot be accessed directly by the users , only the optimizer can access the index.

No comments:

Post a Comment