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 connector, since the Oracle OCI service is designed such that the connector must internally perform time-consuming additional join operations to retrieve this metadata.
When this connection property is set to True, the connector 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.