Re: Indexes on Audit tables?

On Thu, 28 Feb 2002 18:08:43 GMT, "John" <john_at_austin.rr.com> wrote:

>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
>
>
>
>
>
>

Audit tables do typically have no indexes on them, as they are audit tables, and hence used infrequently
, so indexing would
a) slow down the extra audit insert
b) waste space and redo log.
 A temporary index can always be created If you are frequently perceiving full table scans, you should ask whether your audit tables are audit tables. Probably they aren't and they form an integral part of your system.

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Thu Feb 28 2002 - 12:21:32 CST