Hi All

running dbcc dbreindex (table_name,' ',80) did not make any changes to the
scan density (which was 50 to begin with). Any tips on why and what to
look for?

tia
pH


*********************************************************************************
The information transmitted via this e-mail is intended only for the
person or entity to which it is addressed and may contain confidential
and/or privileged material. Any review, retransmission, dissemination
or other use of, or persuing of any action in reliance upon this
information by persons or entities other than the intended recipient is
prohibited. If you are the recipient of this in error, please contact the
sender and delete the material from any computer.
*********************************************************************************

MS Sql Server LazyDBA home page