SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by tklimczak / Generate index on foreign key columns / Latest Posts

RE: Generate index on foreign key columns

mickael.mottet — Thu, 05 Feb 2009 02:01:31 GMT

How can we modify this script to :- Rename [u]all[/u] PK indexes to "IX_[TableName];- Rename [u]all[/u] FK indexes to "IX_[TableName]_[ColumnName]";Thanks

RE: Generate index on foreign key columns

srienstr — Tue, 04 Mar 2008 12:48:38 GMT

[quote][b]Mike Byrd (3/4/2008)[/b][hr]There are times when an index is not needed for a foreign key. If the table is small (low number of rows) or the index column has little selectivity, then why add the overhead of an index? I wrote a similar script about a month ago, but found that the were many times the index just wasn't needed.[/quote]It can be run as just a select first to pull up a list for evaluation. A starting point like that can be useful when you're trying to tune an inherited database.

RE: Generate index on foreign key columns

Mike Byrd — Tue, 04 Mar 2008 12:32:41 GMT

There are times when an index is not needed for a foreign key. If the table is small (low number of rows) or the index column has little selectivity, then why add the overhead of an index? I wrote a similar script about a month ago, but found that the were many times the index just wasn't needed.

RE: Generate index on foreign key columns

srienstr — Tue, 04 Mar 2008 09:09:24 GMT

Which version of SQL Server is this written for? I've got 2000, and neither the table names nor column names match the system tables.

RE: Generate index on foreign key columns

John Mitchell-245523 — Tue, 04 Mar 2008 02:09:00 GMT

Does this work where the foreign key constraint consists of more than one column?John

Generate index on foreign key columns

tklimczak — Wed, 30 Jan 2008 02:16:48 GMT

Comments posted to this topic are about the item [B]Generate index on foreign key columns[/B]