What Does Database Designer Do?
Database Designer uses sophisticated strategies to create physical schemas or database designs. These designs provide excellent query performance while using disk space efficiently.
Database Designer can create two types of designs:
- A comprehensive design allows you to create new projections for all tables in your database.
- A query-specific design creates projections for all tables referenced in the queries you supply to Database Designer.
Database Designer accepts unlimited sample queries for a comprehensive design, It can accept up to 100 sample queries in the query input file for a query-specific design.