Re: Foreign key indexes - to delete?
From: a (a_at_a)
Date: 09/26/04
- Next message: Andrew J. Kelly: "Re: Row size and DBCC SHOWCONTIG"
- Previous message: Andrew J. Kelly: "Re: Filegroups and indexes"
- In reply to: sreckos: "Foreign key indexes - to delete?"
- Next in thread: sreckos: "Re: Foreign key indexes - to delete?"
- Reply: sreckos: "Re: Foreign key indexes - to delete?"
- Messages sorted by: [ date ] [ thread ]
Date: Sun, 26 Sep 2004 18:20:10 -0500
Here is the general rules of thumb I use on all tables:
1. Cluster the Primary Key (PK).
2. Verify FKs and Index them all.
3. Cluster another column instead it PK if performance/requirements indicate
that it would better serve as the clustered index. Then index the primary
key.
4. Actively manage index fragmentation and rate to validate index
FillFactor.
5. Actively manage index usage using Profiler, or other tools, to validate
existing and create new indexes.
Check these out for more informaiton:
http://www.sqlskills.com
http://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032254503&Culture=en-US
http://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032256511&Culture=en-US
Recently www.sqlmag.com had a decent article on scheduling sql traces, but
offhand I don't have the article number.
HTH
Jason Strate
j.s.strate@comcast.net
http://stratesql.blogspot.com
SQL Database Administator and Developer
Microsoft Certifed Professional
"sreckos" <sreckos@discussions.microsoft.com> wrote in message
news:DA3CE2D2-2228-45F3-8E38-C45F01FA6A03@microsoft.com...
> My Powerdesigner helps me design a SQL Server 7 database (approx. 100
tables)
> and automaticaly creates primary key index as well as indexes for all
foreign
> keys in each table.
> So I got a lot of indexes table and I am asking myself whether this is
> correct from performance point of view?
> Wouldn't be better to delete all foreign key indexes, then run Profiler
with
> application functions and define new indexes on the base of Profiler
results?
>
> Thanks for comments!
- Next message: Andrew J. Kelly: "Re: Row size and DBCC SHOWCONTIG"
- Previous message: Andrew J. Kelly: "Re: Filegroups and indexes"
- In reply to: sreckos: "Foreign key indexes - to delete?"
- Next in thread: sreckos: "Re: Foreign key indexes - to delete?"
- Reply: sreckos: "Re: Foreign key indexes - to delete?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
