Hello!!!

I have been in trouble with my SQL Query that was causing time out on the UI...Investigation with DBCC showcontig reveiled that the Scandensity for these tables are 50% or less.

But to my surprise the Scandensity was not improving with REINDEXing and DEFRAG....(Number of rows in these tables are a few hundred only) . I am not sure why is this happening....

to some how escape I tried moving these tables to new ones and saw some improvement in the Scandensity (Query to a improved slightly).

But what puzzles me is why REINDEXing and DEFRAG did't work????

Also one more question....

If I make a backup of this database and restore into a new server will that create new data/index pages?? does that have the same fragmentation as when it was backed up??? or does the RESTORE just uncompress the old pages???

Thanks

Cheriyan.