Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How Creating an Index on Table helps Database engine to do fast Search

 
Ravi Kiran Va
Ranch Hand
Posts: 2234
Eclipse IDE Firefox Browser Redhat
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi

Kept on reading from many sires that Index will help Database engine to do search faster .

For example i have student table with many columns and i had created a index on one of the field



Could anyone please tell me how this helps DB Engine ??
 
Scott Selikoff
author
Saloon Keeper
Posts: 4014
18
Eclipse IDE Flex Google Web Toolkit
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Do you understand how databases search for information? Try reading Wikipedia for more information: http://en.wikipedia.org/wiki/Index_%28database%29
 
Scott Selikoff
author
Saloon Keeper
Posts: 4014
18
Eclipse IDE Flex Google Web Toolkit
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Ravi Kiran V wrote:Could anyone please tell me how this helps DB Engine ??


Actually your question can be rephrased to the non-computer variety... "How does the index in the back of an encyclopedia book help users search for information?". The answers are remarkable similar.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic