Re: number <-> number(x,y) foreign keys: performance impact ?

"G Dahler" <gd-nntp3_at_spamex.com> a écrit dans le message de news: OKHLf.7122$XZ3.317017_at_news20.bellglobal.com...
|I rand a script to check the health status of my database and it reports a
| problem with some foreign keys where the referenced columns and the
| referencing columns are of a different data type.
|
| My question is:
|
| Does oracle have to do conversion between a number column and a number(x,y)
| column ?
|
| If so, that means that my joins are not optimal.
|
| Thanks.
|
|

No difference.
(x,y) is just a constraint like null/not null... A number is a number whatever its definition is.

Regards
Michel Cadot Received on Fri Feb 24 2006 - 12:21:49 CST