execution plan

Hi ,
The execution plan shows the estimated rows count and row
count which a big diff means the statistics is not up to
date ?
which utility will show the logical scan and extended
scan which high % means the index is fragemented ?
and also is there any help on how to interpret the results
return by the statistics ?
thks & rdgs
Hi,
Use the command DBCC SHOWCONTIG to get the fragmentation information. See
books online for command usage and details.
You could update the statistics of the table using the below command and see
the execution plan again
update statistics <table_name>
Thanks
Hari
MCDBA
"maxzsim" <anonymous@.discussions.microsoft.com> wrote in message
news:afb901c488cf$55873a70$a401280a@.phx.gbl...
> Hi ,
> The execution plan shows the estimated rows count and row
> count which a big diff means the statistics is not up to
> date ?
> which utility will show the logical scan and extended
> scan which high % means the index is fragemented ?
> and also is there any help on how to interpret the results
> return by the statistics ?
> thks & rdgs
|||Perhaps it would be better to update the statistics with the FULLSCAN option
if you are still getting sub-optimal plans.
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backups? Use MiniSQLBackup Lite, free
"maxzsim" <anonymous@.discussions.microsoft.com> wrote in message
news:afb901c488cf$55873a70$a401280a@.phx.gbl...
> Hi ,
> The execution plan shows the estimated rows count and row
> count which a big diff means the statistics is not up to
> date ?
> which utility will show the logical scan and extended
> scan which high % means the index is fragemented ?
> and also is there any help on how to interpret the results
> return by the statistics ?
> thks & rdgs