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

Home -> Community -> Usenet -> c.d.o.server -> Determine if column is never used?

Determine if column is never used?

From: <chrisoc_at_ans.net>
Date: Wed, 27 Oct 1999 17:15:50 GMT
Message-ID: <7v7c01$7kp$1@nnrp1.deja.com> 







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



I am dealing with a legacy database that is highly unnormalized and
a few tables in it have literally hundreds of columns.



Going through megs of app source (ughhh) would still miss the adhoc
queries  so I want evidence that some data is indeed "dead weight",
if I can get at the numbers.




Chris O'Connor







Sent via Deja.com http://www.deja.com/



Before you buy.
Received on Wed Oct 27 1999 - 12:15:50 CDT












Original text of this message













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