How to solve the FK's w/o Matching Indexes (or an unusable one) (# tables)

Toad for Oracle
1

Hi gurus.
Can you please help me understand and fix this issue?

FK’s w/o Matching Indexes (or an unusable one)

Regards,
Ed

2

Check if there is an index on the foreign key (doesn’t get created by default).
Also check if the parent-child fields have the same datatype and size

3

Hi Flyby,
There is an indexes which is unique one related to the PK, datatype are the same, still not understand why toad is listing it.

4

Evening Ed,

2012? That was a while ago. Never mind, I'm glad it was useful. And thanks for getting back to me.

Cheers,

Norm [ TeamT ].

On 30 April 2015 01:27:28 BST, Ed D'Agostini bounce-EdDAgostini@toadworld.com wrote:

RE: How to solve the FK's w/o Matching Indexes (or an unusable one) (#
tables)

Reply by Ed D'Agostini
Hi Norm.

Sorry to take so long to get back to you.

I really appreciated the way you explained it to me. Thank you very very much.

Regards,

Ed

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or Unsubscribe from Oracle notifications altogether.

Toad World - Oracle Discussion Forum

Flag this post as spam/abuse.

--

Sent from my Android device with K-9 Mail. Please excuse my brevity.