performace question...

From: Vince Laurent <eAddict_at_yahoo.com>
Date: Tue, 13 Apr 2004 09:45:29 -0500
Message-ID: <d4vn705otlrjv6li6g0ku9h1uteamse0og@4ax.com>

Quick question: Are full table scans bad for performance? I am guessing yes. I ran this script:

set serverout on size 1000000
set verify off

col object_name form a30

PROMPT Column flag in x$bh table is set to value 0x80000, when PROMPT block was read by a sequential scan.

spool bufferts.lst

SELECT o.object_name,o.object_type,o.owner FROM dba_objects o,x$bh x
WHERE x.obj=o.object_id
AND o.object_type='TABLE'
AND standard.bitand(x.flag,524288)>0
AND o.owner<>'SYS';

spool off

and the result on one of our DB was 5600! Since Sunday's backup! How can I tell the vendor that thier appliction, um, er... works harder than it needs to?

Thanks

---

Come race with us!
www.mgpmrc.org Received on Tue Apr 13 2004 - 09:45:29 CDT