CODEWITHSUNDEEP
databasevertica
Up_One
Up_One

Reputation: 5271

How to create query specific projections with Vertica Database Designer?

How should the script be fed to Vertica's database designer when I want to create query-specific projections ?
Can I write more then one SELECT statement inside the file that will be provided as input to the DB designer?

Upvotes: 1

Views: 1298

Answers (1)

QuinnG
QuinnG

Reputation: 6424

Create a text file with the queries you want to optimize for. When prompted in the DBD process, point it to that file.

When I was working on/discussing optimxation using Vertica Database Designer it seems like the recommended upper limit for queries in the file was 100.

If you want to weigh a query more heavily, put that in multiple times.

Upvotes: 3

Related Questions