Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Foreign Keys and performance

tkandlFeb 17 2014 — edited Feb 19 2014

Hi all,

I have a question regarding wether to use foreign keys or not.

In the performing tuning section of the times ten operations guide it is stated:

The declaration of a foreign key has no performance impact on SELECT queries, ...

My question is, if anybody has any experience with this. Since the foreign key indexes need much memory (in our case much more than the table itself), we would rather avoid them if possible.

Thanks,

Thomas
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 19 2014
Added on Feb 17 2014
#database-key-features, #performance, #timesten-in-memory-database
6 comments
3,617 views