db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dan Karp <dk...@zimbra.com>
Subject Foreign key -- implicit index?
Date Sat, 17 Mar 2007 18:00:20 GMT
Just to make sure, this foreign key declaration

   CONSTRAINT fk_mail_item_parent_id FOREIGN KEY (mailbox_id, parent_id)
     REFERENCES ${DATABASE_NAME}.mail_item(mailbox_id, id),

implicitly creates an index on (mailbox_id, parent_id), right?

Mime
View raw message