Home » RDBMS Server » Server Administration » identify tables used in table scans (long)
identify tables used in table scans (long) [message #52096] Tue, 02 July 2002 06:32 Go to next message
Tim Sykes
Messages: 1
Registered: July 2002
Junior Member
How do you identify, using sql, which tables are being accessed by full table scans by currently executing sql?

Report message to a moderator

Re: identify tables used in table scans (long) [message #52100 is a reply to message #52096] Tue, 02 July 2002 06:54 Go to previous message
saleem
Messages: 65
Registered: January 2002
Member
you'll have to run an explain plan on the query in question and see from there which tables are being accessed and in what fashion.

Report message to a moderator

Previous Topic: Automatic Process for Pinning Packages under WinNT/2K
Next Topic: Tablespace RBS is used in 99%
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Sep 17 20:22:45 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.