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?
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL