dbTalk Databases Forums  

Indexing my db

microsoft.public.sqlserver.clients microsoft.public.sqlserver.clients


Discuss Indexing my db in the microsoft.public.sqlserver.clients forum.



Reply
 
Thread Tools Display Modes
  #41  
Old   
Russell Fields
 
Posts: n/a

Default Re: Indexing my db - 06-12-2008 , 12:08 PM






KS,

When you create new indexes they are built at that time, with no further
steps needed. Also, a new index has up-to-date statistics, so you should
not need to update them.

However, changes to data can cause the cached statistics on the row counts
per key ranges to age, so if an index has been around for a while, it may be
helpful to do an UPDATE STATISTICS or sp_updatestats. Also, you can defrag
the indexes using DBCC REINDEX or DBCC INDEXDEFRAG (or in SQL Server 2005,
ALTER INDEX ... REBUILD).

But, of course, the main issue is to create indexes that are useful to your
queries.

RLF

"KS soerensen (AT) os (DOT) dk>" <keld.<SLET_DETTE> wrote

Quote:
"... have you updadted the STATISTICS"

What do you mean ?

Best regards
KSO, Denmark

"vinu" <vinu.t.1976 (AT) gmail (DOT) com> skrev i meddelelsen
news:ulZlvIIzIHA.4864 (AT) TK2MSFTNGP06 (DOT) phx.gbl...
HI

Are you sure that the index are on the right column that the application
needed, have you updadted the STATISTICS

regards
vinu

"KSO" <kso (AT) psa (DOT) dk> wrote in message
news:%2302aVHHzIHA.2068 (AT) TK2MSFTNGP05 (DOT) phx.gbl...
I have indexed my db and I don't think it has speeded it up at all !

Do I have to "build" the indexes or anything else ?

Best regards
KSO, Denmark








Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.