Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Indexes on Audit tables?

Indexes on Audit tables?

From: John <john_at_austin.rr.com>
Date: Thu, 28 Feb 2002 18:08:43 GMT
Message-ID: <Lmuf8.28983$0y2.1530195@typhoon.austin.rr.com> 





Hi, Do audit tables typically have indexes associated with them. Our dba's
have setup auditing on our database, and I am creating queries against them.
Problem is that all of the audit tables are giving me full table scans and
I've noticed that there are no indices on any of the audit tables. Is it a
simple matter of adding indexes or for some reason, are there not supposed
to be indexes on them?



Thanks,


John
Received on Thu Feb 28 2002 - 12:08:43 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US