indexes ?

Question

indexes ?

bang.prashant

Ten Centuries

Points: 1100
More actions
October 7, 2008 at 9:20 am

#131582

can you tell me which method is better and why ? and when to implement?
1. Drop and recreate Indexes
2. DBCC DBREINDEX
3.DBCC INDEXDEFRAG
4. Rebuild indexes
5. Reorgnize indexes

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply

Luke L SSC-Dedicated Points: 35545 More actions · Answer 1

The easy answer is It Depends. Read the Books online sections on each of these. That will help give you a good understanding of what each one does. Then perhaps you could post a more specific question about what to use in your situation and we could give you a better recommendation.

-Luke.

To help us help you read this[/url]For better help with performance problems please read this[/url]

bang.prashant Ten Centuries Points: 1100 More actions · Answer 2

i have error like

the index entry for row id 94 was not found in index id 121348304584

now which method need to do and why?

Gail Shaw SSC Guru Points: 1004494 More actions · Answer 3

None of the above. You've got database corruption. Please run the following and post the results.

DBCC CHECKDB(< Database Name > ) WITH NO_INFOMSGS

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

bang.prashant Ten Centuries Points: 1100 More actions · Answer 4

hi

my db is around 1000 gig ? checkdb will take lot of time

need some alternate fastest solutions

Gail Shaw SSC Guru Points: 1004494 More actions · Answer 5

Yes, it will take time. Probably a couple of hours. You still need to do it.

At this point you have an unknown amount of corruption of unknown severity in that database. I can't suggest a solution to that without getting rid of the unknowns. The only way to do that is to run a full database integrity check

If you just want to check the one table, then use DBCC CheckTable, with the same options. If you do that, post the results.

I strongly suggest you run a checkDB as soon as possible. There may be other tables corrupt, there may be damage to allocation structures, etc. We just don't know

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

bang.prashant Ten Centuries Points: 1100 More actions · Answer 6