Re: ccol$

d.a. wrote:
>
> Anyone know what would cause this sql to be executed in a database over 2
> million times per day?
>
> select intcol#,nvl(pos#,0),col# from ccol$ where con#=:1
>
> Thanks, -Dan

Lookups for constraint columns...

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."