This blog has moved to http://ikhwanhayat.net

Monday, March 20, 2006

SQL Server Indexes

In my previous entry, I asked a question : "I wonder what is the difference between creating an index consisting of two column, compared to creating 2 index (one for each column)?" I, myself, was not sure to whom did I address this question, but I manage to get some answers today.

SQL Server Indexes http://www.odetocode.com/Articles/70.aspx

Contains some very good explainations on how database indices works (SQL Server to be exact), about composite index (one index containing multiple column), clustered vs unclustered Index, and some guidelines on using them.

2 Comments:

At 6/30/2006 12:56:00 am, Anonymous Anonymous said...

Thanks, I'm glad you enjoyed the article.

--
Scott
http://www.OdeToCode.com/blogs/scott/

 
At 6/30/2006 01:10:00 am, Blogger Ikhwan Hayat said...

No, no. Thanks to you, for writing and sharing the article :)

 

Post a Comment

<< Home