Re: Determine if column is never used?

You've all confirmed my suspicion this would not be a picnic.

Sure would be a cool utility for someone with knowledge of internals to make some money with. A few hundred dollars to save time/storage/backup media/maintenance/aggravation/bandwidth? I'd pay!

 Meanwhile I
like the idea of taking an educated guess and creating a view, seeing what breaks and adding to the view when we have to. Finally, do something about the underlying table's unneeded data and structure.

Chris O'Connor

In article <7v7c01$7kp$1_at_nnrp1.deja.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.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Oct 28 1999 - 10:42:33 CDT