The Database Designer is a tool
that recommends a physical database design (projections) that provides the best
performance to answer your query needs. This is useful because it minimizes the
time the DBA spends on physical database tuning and provides the ability to
re-design the database incrementally to optimize for changing workloads over
time.
You can run the Database
Designer before or after a Vertica database has been deployed, and it runs as a
background process.
When you use the Database
Designer to create a design, the DBA provides the following inputs:
·
Logical schema (CREATE TABLE statements)
·
Sample data
·
A sample set of queries that represent what you'd normally run
·
A K-safety level
For More Info:
https://my.vertica.com/docs/5.0/HTML/Master/14415.htm
No comments:
Post a Comment