Foreign Key Constraints

sherihan · **Joined:** Tue Dec 21, 2004 3:18 am **Posts:** 32

Hi,
I would like to know, if I removed all foreign key constraints from the database,
will that affect hibernate performance in any way.

Does hibernate depend on foreign key constraints in anything (for example in cascading updates or deletes) or does it use the model objects only?

Thanks in Advance.

kgignatyev · **Posted:** Mon Nov 14, 2005 1:25 pm

sherihan wrote:

Does hibernate depend on foreign key constraints in anything (for example in cascading updates or deletes) or does it use the model objects only?

H relies on Object Mappings.

sherihan wrote:

I would like to know, if I removed all foreign key constraints from the database,
will that affect hibernate performance in any way.

It will potentially worsen read performance and improve "insert/update" performance.

IMO: removing all the constraints from DB is a very bad idea.

snpesnpe · **Joined:** Sat Jun 12, 2004 4:49 pm **Posts:** 915

foreign key don't create index (for oracle, i don't sure for another database) and deleting foreign key don't touch performance except that preformance insert/update is better (no checking)

if you create index for foreign key and delete it (index don't depend from foreign key) then you will have worst select performance