ShowMetadataDescriptions
Controls whether table and column descriptions are returned via the platform metadata APIs and sys_tables / sys_views / sys_tablecolumns.
Data Type
bool
Default Value
false
Remarks
By default, table and column descriptions are not shown in the system tables of the add-in, since the Oracle OCI service is designed such that the add-in must internally perform time-consuming additional join operations to retrieve this metadata.
When this connection property is set to True, the add-in returns table and column descriptions in system tables, but the join operations required to return these results leads to reduced performance for metadata operations on large datasets.