Re: C constraints

Dudo wrote:
>
> The CONSTRAINT_TYPE column in USER_CONSTRAINTS has only one value for all
> the tables:
> "C"
> No P or U or R ...
> What does it mean for performance?
> If it isn't easy to explain, can you suggest any article on subject?
>
> Thanks

'C' - check something
'P' - primary key
'U' - unique
'R' - foreign key

If its a pre-delivered app then it may not take advantage of Oracle specific stuff - otherwise its worth a closer look...

hth
connor

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk (mirrored at
http://www.oradba.freeserve.co.uk)

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