>
>Have you done performace tests with a clustered index and one without?
>
See my benchmark script elsewhere in this thread
>If this link table is joining many rows that meet a range of criteria, the clustered index will improve throughput dramatically since the data is all on the same data page.
>
Yes, I agree, but again, as I said, this is a table that is very rarely queried against. It is used as a link table in what is, effectively, and auditing module. Loads and loads and loads of inserts. A query every month or two, maybe - and speed isn't an issue.
The whole problem with the world is that fools and fanatics are always so certain of themselves, but wiser people so full of doubts. - Bertrand Russell
