This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes JDBC and the fly likes How Creating an Index on Table helps Database engine to do fast Search Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "How Creating an Index on Table helps Database engine to do fast Search" Watch "How Creating an Index on Table helps Database engine to do fast Search" New topic
Author

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

Ravi Kiran Va
Ranch Hand

Joined: Apr 18, 2009
Posts: 2234

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 ??


Save India From Corruption - Anna Hazare.
Scott Selikoff
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3703
    
    5

Do you understand how databases search for information? Try reading Wikipedia for more information: http://en.wikipedia.org/wiki/Index_%28database%29


My Blog: Down Home Country Coding with Scott Selikoff
Scott Selikoff
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3703
    
    5

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.
 
 
subject: How Creating an Index on Table helps Database engine to do fast Search
 
Similar Threads
Performance hit using "where" clause in the query
when to index column(s)
what si the specialty of this Hibernate Search
Searching technique used by SQL server
Hibernate Search in Action: What do you mean by Search exactly?