Hi David,

Thanks for this descriptive tutorial. I clearly understood the Non-clustered and Clustered Indexes. Still few questions roaming around my brain which are as follows...

1. In Non clustered Index, Index key is sequential or non sequential?

2. Since Non clustered Index has its own space in memory, is it possible for us to view an index he moment we define it for a table?

3. The example of Finding hat Size using Index Key (Last Name, First Name) and BookMark (Phone Number) was clear to me. Still if I need to see this in a Table, i.e. relating index and bookmark to find "searched data". May you please help in providing an example on that.

Thanks much

-Sandeep