Skip to main content
Question

DBD: Selecting a table vs. schema to optimize

  • April 2, 2020
  • 1 reply
  • 7 views

DreaBrandford

Does current DBD version have the next granularity level to table name (object name) within a schema rather than full schema level. If not then we have to copy a set of tables to a separate schema in-order to run DBD.

Asked during BDC session Vertica Database Designer – Today and Tomorrow
@ybei

1 reply

Jan_Soubusta
Forum|alt.badge.img
  • Participating Frequently
  • April 6, 2020

https://www.vertica.com/docs/9.3.x/HTML/Content/Authoring/SQLReferenceManual/Functions/VerticaFunctions/DatabaseDesigner/DESIGNER_ADD_DESIGN_TABLES.htm
You can specify list of tables instead of schema.*
Personally I would appreciate an option to specify wildcard in table name as well, something like schema.analytics_*, but it is not a part of the product.
On the other hand when using DBD programmatically, a developer can easily generate the list of tables from database catalog.