Groups > comp.databases.ms-sqlserver > #1438

Re: Elementary management of many indexes, index and statistics names

Path	csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!eu.feeder.erje.net!eternal-september.org!feeder.eternal-september.org!mx05.eternal-september.org!.POSTED!not-for-mail
From	Erland Sommarskog <esquel@sommarskog.se>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: Elementary management of many indexes, index and statistics names
Date	Sat, 06 Apr 2013 11:53:14 +0200
Organization	Erland Sommarskog
Lines	19
Message-ID	<XnsA19A78ECC4CBDYazorman@127.0.0.1> (permalink)
References	<d87de084-20ee-4c81-bc5b-e235f51b6fda@googlegroups.com> <XnsA199D0419269FYazorman@127.0.0.1> <f188c0b8-1844-481c-9078-4016544220bb@googlegroups.com>
Mime-Version	1.0
Content-Type	text/plain; charset=windows-1252
Content-Transfer-Encoding	8bit
Injection-Info	mx05.eternal-september.org; posting-host="78e2ae7e6764121e217a035f19bdb315"; logging-data="22251"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1+TQxTomDp7swxJB6qQHvCX"
User-Agent	Xnews/2006.08.24 Mime-proxy/2.1.c.0 (Win32)
Cancel-Lock	sha1:OLmOm2uhEleuePBvoGekm5v+kow=
Xref	csiph.com comp.databases.ms-sqlserver:1438

Show key headers only | View raw

 (rja.carnegie@gmail.com) writes:
> I'll take "yes, you can", thank you.  I /could/ generate distinct
> index names by a rational system, but will that make queries run
> faster?  I don't think so.  

Of course, you are right that index names and performance are entirely
unrelated. It's only a matter of manageability. What if you decide 
to put those table in the same schema? 

It's not a big deal, but since you are generating the name anyway, it's
not difficult to build unique index names by using schema and table name.

-- 
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Find similar

Thread

Elementary management of many indexes, index and statistics names rja.carnegie@gmail.com - 2013-04-05 07:59 -0700
  Re: Elementary management of many indexes, index and statistics names "Bob Barrows" <reb01501@NOSPAMyahoo.com> - 2013-04-05 12:36 -0400
  Re: Elementary management of many indexes, index and statistics names "Bob Barrows" <reb01501@NOSPAMyahoo.com> - 2013-04-05 12:44 -0400
  Re: Elementary management of many indexes, index and statistics names Erland Sommarskog <esquel@sommarskog.se> - 2013-04-05 20:28 +0200
    Re: Elementary management of many indexes, index and statistics names rja.carnegie@gmail.com - 2013-04-05 15:49 -0700
      Re: Elementary management of many indexes, index and statistics names Erland Sommarskog <esquel@sommarskog.se> - 2013-04-06 11:53 +0200

csiph-web