Link Details

When we create index on table field what actually does is create meta data on that field of a table and point it to original field along with that it sort the meta data that is just created for that particular field this way when we run query on that specific field, in background database will search on that meta data that is just created as it’s already sorted the database will find the data faster than we search on the main table.

Posted by khodem  |   Submitted: Dec 29 2013 / 09:32

Add your comment

Html tags not supported. Reply is editable for 5 minutes. Use [code lang="java|ruby|sql|css|xml"][/code] to post code snippets.

Recommended Links

Written by: Ryan Knight
Featured Refcardz: Top Refcardz:
  1. Apache Hadoop
  2. Play
  3. Akka
  4. Debugging JavaScript
  5. Design Patterns
  1. Apache Hadoop
  2. REST
  3. Java
  4. Git
  5. Java Performance
Connect with DZone