Toad World® Forums

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

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

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

Regards,
Ed

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

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.

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.