SQL Server Performance Forum – Threads Archive

creation indexes

if i get a task like that to create index on table what index i should create first on table why? what is difference between dbcc rebuild indes and dbccdefragment ? SRJ2005

As far I know there is no dbcc defragment. To find out how fragmented you tables are, I suggest to read your question in :
http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=11961 About rebuild indexes (DBCC DBREINDEX) has the following options: DBCC DBREINDEX
( ‘database.owner.table_name’
[ , index_name
[ , fillfactor ]
]
) [ WITH NO_INFOMSGS ] So, you can defrag any index in any table or defrag all indexes in all databases (using maintenance plan), but is not usefull to defrag indexes with lest than 85% of fragmentation.
What I do is to run one store procedure (written by Tom Pullen and you can find it in articles) to defrag only those indexes with fragmentation below 85 ( in Tom procedure you can define that %). You can create a job with that sp and run it in windows time, said 3 times a week. Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided â€œAS ISâ€ with no warranties for accuracy.

http://www.devx.com/dbzone/Article/29530
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/tunesql.mspx
http://www.sql-server-performance.com/optimizing_indexes.asp
http://www.sql-server-performance.com/nonclustered_indexes.asp Fyi. Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Are you preparing for an exam or interview?

]]>