Referential integrity without index [CORE2743]

FirebirdSQL / firebird

Firebird server, client and tools

https://www.firebirdsql.org/

1.24k stars 215 forks source link

Referential integrity without index [CORE2743] #3138

Open firebird-automations opened 14 years ago

firebird-automations commented 14 years ago

Submitted by: Dejan Schild (schild)

Votes: 4

Optionally to create foreign key constraint without creating index on it. In some cases this is a duplicate unusable indexes. On big tables that impact performance.

firebird-automations commented 14 years ago

Commented by: Ann Harrison (awharrison)

This is a non-trivial change because foreign key checking is done in the index code. It would be easier to recognize that an existing index could be used than to allow a constraint without any index at all.