Link Details

Link 1087883 thumbnail
User 1206035 avatar

By khodem
via dbdiary.com
Submitted: Dec 29 2013 / 09:32

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.
  • 2
  • 0
  • 184
  • 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.

Voters For This Link (2)



Voters Against This Link (0)



    Play Framework
    Written by: Ryan Knight
    Featured Refcardz: Top Refcardz:
    1. Akka
    2. Design Patterns
    3. OO JS
    4. Cont. Delivery
    5. HTML5 Mobile
    1. Akka
    2. JUnit/EasyMock
    3. Java Performance
    4. REST
    5. Java