Did you notice that at the top of each page is the first and last name of the page? And that the pages themselves are in alphabetical order? That is an index.In general it is similar, but it is not how B-Tree indexing works.
Prashant Verma wrote:Ok, then be a regular reader of http://richardfoote.wordpress.com/
Apart from index basics, I want to know for B- Tree index logics and BITMAP..
965342 wrote:Actually, if you google a little bit more thoroughly you'll see that's not quite true:
Google how bitmap indexes work, once you understand how they work you'll see why they're so good for low cardinallity (and bad for high cardinallty).