Re: Determine if column is never used?

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Wed, 27 Oct 1999 21:41:03 +0800
Message-ID: <381700EF.2F@yahoo.com>

chrisoc_at_ans.net wrote:
>
> 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.

The heavy handed way...

1. rename the table
2. create a view using the original name without the column

see what falls over...
--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Wed Oct 27 1999 - 08:41:03 CDT