Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

A database view defines table joins for reporting purposes:

...

  • The accumulated impact on performance grows as the number of tables that are included in the view and the number of records that those tables contain increase. To maximize the performance of the database view, ensure that the ‘where’ clauses that are defined in the database view are based on indexed fields.

  • A database view is not treated like a custom table, so there is no licensing impact.

  • Database view tables are not included in FTP exports.

Limitations

  • Database Views cannot be created on tables that participate in table rotation.

  • It is not possible to edit data in the Database View output.

  • Database View tables cannot be added as a data preserver in clone requests

...