Issue Details (XML | Word | Printable)

Key: CORE-2743
Type: New Feature New Feature
Status: Open Open
Priority: Major Major
Assignee: Unassigned
Reporter: Dejan Schild
Votes: 4
Watchers: 4

If you were logged in you would be able to see more operations.
Firebird Core

Referential integrity without index

Created: 08/Nov/09 04:32 PM   Updated: 08/Nov/09 10:04 PM
Component/s: Engine
Affects Version/s: None
Fix Version/s: None

 Description  « Hide
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.

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Ann Harrison added a comment - 08/Nov/09 10:04 PM
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.