Re: Indexes on Audit tables?

From: damorgan <dan.morgan_at_ci.seattle.wa.us>
Date: Thu, 28 Feb 2002 19:41:31 GMT
Message-ID: <3C7E87EF.1CBB23A7@ci.seattle.wa.us>

The purpose of indexes is to speed up DML (select, insert, update, delete). So the question is how often are you querying the audit tables and is performance an issue. If not ... drop them. If so ... then perhaps they are of value.

Daniel Morgan

John 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
Received on Thu Feb 28 2002 - 13:41:31 CST