Re: Determine if column is never used?

From: Andy Cowling <arc_at_sequent.com>
Date: 28 Oct 1999 10:10:11 +0100
Message-ID: <85k8o7svf0.fsf@lapwing.uk.sequent.com>

>>>>> "chrisoc" == chrisoc <chrisoc_at_ans.net> writes:

    chrisoc> Is there a way to see the stats on column access within a
    chrisoc> table?  The goal would be to either drop columns entirely
    chrisoc> or to build new tables that could be joined if the need
    chrisoc> exists but the frequency is rare.

Pine Cone Systems have a commercial product (Usage Tracker) that can do this. It listens on the SQL*Net port, pumps out data to another separate Oracle repository for Q&R and forwards the packets untouched to the SQl*Net listener.

http://www.pine-cone.com/ Received on Thu Oct 28 1999 - 04:10:11 CDT