Informational constraints on nicknames

You can use informational constraints on nicknames to improve the performance of queries. Informational constraints are rules that the optimizer uses to improve performance but that the database manager does not enforce.

You can specify the following for nicknames:
  • Referential constraints
  • Check constraints
  • Functional dependency constraints
  • Primary key constraints
  • Unique constraints