Saturday, 21 November 2015

What is DBD in Vertica?



    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