Re: Optimize SQL

From: Student <kennylim_at_techie.com>
Date: Tue, 24 Jul 2001 10:47:46 -0700
Message-ID: <9jkbve$ai1$1@nntp9.atl.mindspring.net>

Hi folks,

Out of curiosity..

It's there a way to better optimize this query (in terms of elapsed time) that is running against the construct of 2 oracle views ? or this is the best it gets when querying against the oracle data dictionary.

SELECT A.PRIVILEGE, A.OWNER, A.TABLE_NAME,A.GRANTABLE, A.GRANTOR, A.GRANTEE, B.OBJECT_TYPE
FROM DBA_TAB_PRIVS A, DBA_OBJECTS B
WHERE GRANTEE='DBA'
AND B.OWNER = A.OWNER
AND B.OBJECT_NAME = A.TABLE_NAME Any advise would be appreciated. Thanks folks.

Student-- Received on Tue Jul 24 2001 - 12:47:46 CDT