yuvipoy (3/6/2014)

---

Thanks Sean!

I got it we should not go with cluster index for guid since this will cause physical ordering of the data on the disk which is pointless one.

One more thing

how about Selecting the statement

Select <set of columns> from table where Col_uniqueidentifier={uniqueidentifier}

say now if the column is with py key non cluster index with 10 million record will the query will be faster to return data ?

or the query with col_bigint column instead of col_uniqueidentifier

Select <set of columns> from table where col_bigint ={bigint }

say now if the column is with py key (non) cluster index with 10 million record will the query will be faster to return data ?

Can you suggest on this