-
Scan Density Does'nt improve after rebuilding Index
Hi,
I have few tables in my database.Even though i dropped and recreated the indexes on these tables the scan density is not changing(less than 50%).I also got a stack dump when a report involving huge select statement is ran against the database.Before stack dump I noticed an error tempdb cannot allocate new page.I checked the size of tempdb it has space.It is set to auto grow and disk has more than 2.5 gig of free space.
I appreciate if anyone can help me to figure out what is happening on this database.
thanks
Mohan
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|