Re: Trace access to one specific table

"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message news:bqle48$kms$1$8302bc10_at_news.demon.co.uk...
>
> There is an un(der)-documented feature in
> v9 that monitors the way that columns are
> used in predicates. The information is updated
> in table sys.col_usage$, identifying the column
> by object number, and internal column position
> The content is maintained at intervals by smon,
> so can be a little out of date; but it lists number
> of predicates which were for:
> equality checks
> equijoins
> non-equijoins
> range predicates
> like predicates
> null predicates
> so you can get a good idea of how the table is
> accessed, and how frequently.
>
> This may help.

Thanks, I will try to figure something out from that table... At first glance, it wasn't completely obvious, but that's what makes the whole thing worthwhile, right?

Best regards
Frank Foss Received on Thu Dec 04 2003 - 10:32:11 CST