469,267 Members | 971 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,267 developers. It's quick & easy.

how to monitor for full table scans?

How-doody all. Is there an easy way to identify tables that are not
properly indexed based on how often sessions are performing full table
scans on it?
Jul 20 '05 #1
1 3624

"sumGirl" <em*****@netscape.net> wrote in message
news:a5**************************@posting.google.c om...
How-doody all. Is there an easy way to identify tables that are not
properly indexed based on how often sessions are performing full table
scans on it?


Probably the easiest thing is to trace normal activity on the server with
Profiler, then use that trace as input to the Index Tuning Wizard - that
should give you a starting point.

Simon
Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Carlos Ibarra | last post: by
5 posts views Thread by Bruce Pullen | last post: by
2 posts views Thread by db2udbgirl | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.