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?
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center