Win a copy of Murach's Python Programming this week in the Jython/Python forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Index Concept of Data base  RSS feed

 
Neel Sharma
Greenhorn
Posts: 12
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
This is not related to any java topics.. But i need to know in detail about indices.

I read about clustured and Non clustured index on many websites but i did'nt get an exact idea of them.

In clustured index the physical ordering of the data is sorted and in non-clustred logical ordering is sorted, what it exactly means?

I appreciate if any one can explain this in detail with example.


Thanks
Neel
 
Jeanne Boyarsky
author & internet detective
Sheriff
Posts: 36406
454
Eclipse IDE Java VI Editor
  • Likes 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Wikipedia describes this well. Take a look at that and then ask a more specific question here about what you don't understand.
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!