Along with database design, Indexes are the backbone of optimal database performance. It requires specialist knowledge to ensure that you have the right indexes for the right job and this article will provide you with enough knowledge to make the right choices - and to know when to use an index and when not.
We will also take a look at the different types of indexes that exist (clustered, non-clustered, covering indexes and indexing views), what each does and any restrictions on the use of that index.
Robin is a SQL Server and Visual Basic consultant currently assigned to Lehman Brothers in London, England.
He enjoys Laurel and Hardy movies, and Rugby Football. He listens to 6Music from the BBC a great deal (see cool links) and can be found from a link on his home page