Sample queries with optimization objectives in DBD

Moderator: NorbertKrupa

Post Reply
NorbertKrupa
GURU
GURU
Posts: 527
Joined: Tue Oct 22, 2013 9:36 pm
Location: Chicago, IL
Contact:

Sample queries with optimization objectives in DBD

Post by NorbertKrupa » Thu Jan 16, 2014 9:54 pm

When running a database designer with different optimization objectives (balanced query/load, query performance or load performance), how are the sample queries weighed? If there are more load sample queries, will the database designer favor the load performance and vise versa? Does the DBD consider load/insert statements when examining sample queries?

Cross posting from the Vertica community to get more visibility.
Checkout vertica.tips for more Vertica resources.

Post Reply

Return to “Vertica Performance Tuning”