Are FK constraints necessary?

Moderator: NorbertKrupa

Post Reply
User avatar
usli06
Intermediate
Intermediate
Posts: 93
Joined: Wed Jan 25, 2012 4:53 am

Are FK constraints necessary?

Post by usli06 » Thu Jun 28, 2012 11:47 am

Hi,

Do FK constraints help with query performance in Vertica? Are they even needed? Our ETL already takes care of any parent child relationships accordingly.

Thanks
Top
jpcavanaugh
Intermediate
Intermediate
Posts: 149
Joined: Mon Apr 30, 2012 10:04 pm
Location: New York
Contact:
Contact jpcavanaugh

Re: Are FK constraints necessary?

Post by jpcavanaugh » Thu Jun 28, 2012 12:40 pm

FK constraints help the engine determine join order. If you are already getting the best join path then they are not of a huge use.
Top
Post Reply

Return to “New to Vertica Database Administration”