Reply to Re: Indexes on SQL Server 7.0

Your name:

Reply:


Posted by Hugo Kornelis on 03/27/07 21:34

On 26 Mar 2007 21:29:32 -0700, othellomy@yahoo.com wrote:

>> Doesn't seem to be to be very beneficial to have an index that only
>> includes the primary key. So for example I'm thinking of creating an
>> index for MatterConflicts that includes the fields: MatterConflicts,
>> Matters, and HitMatters.
>
>no. Don't use composite indexs as they seldom are useful.

Hi othellomy,

Do you have any source for that sweeping statement?

AFAIK, composite indexes can be VERY useful. For queries that filter or
join on two or more columns, a composite index is much better than
seperate indexes on the individual columns.

--
Hugo Kornelis, SQL Server MVP
My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis

[Back to original message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация