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
Are FK constraints necessary?
Moderator: NorbertKrupa
-
- Intermediate
- Posts: 149
- Joined: Mon Apr 30, 2012 10:04 pm
- Location: New York
- Contact:
Re: Are FK constraints necessary?
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.