Interesting. Can you point me to some simple article explaining indexes type in SQL Server? I don't have SQL installed on my PC, so direct link would be great.
Thanks a lot in advance.
>I'm guessing the biggest advantage to 3 is that option 2 has an extra index that is being maintained for no reason. The one on lineID by itself might never be used.
>
>Thanks again for the reply.
>
>>I think so. But I think using invoice no. in primary key, since it will be part of the primary method of selecting recs also helps.
>>
>>
If it's not broken, fix it until it is.
My Blog