Re: Optimize SQL
From: Student <kennylim_at_techie.com>
Date: Tue, 24 Jul 2001 10:47:46 -0700
Message-ID: <9jkbve$ai1$1_at_nntp9.atl.mindspring.net>
Date: Tue, 24 Jul 2001 10:47:46 -0700
Message-ID: <9jkbve$ai1$1_at_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 - 19:47:46 CEST