Hi -

I am working on a program that does a great deal of searching and sorting
through very large recordsets. Currently, the performance is just ok. I
am hoping to do better than that and one way of doing so that I have been
told about is through the use of clustered indexes.

Now, after doing some reading about clustered indexes I am thinking that
this might be a really good approach. I am thinking about placing multiple
fields within the clustered index but have been told that that approach will
ultimately be counter productive.

To clear up the confusion can someone please provide a brief overview of
the best/worst uses for a clustered index?

Many thanks