Using Pass-through Optimization with Oracle Data Source Clients
Pass-through optimization affects DATE and TIMESTAMP data types in Oracle data sources. The default value of Pass Thru Optimizations is true. To take advantage of this optimization for 6.1.0.1 JDBC clients, leave it set it to true. Set it to false for pre-6.1.0.1 JDBC, ODBC and ADO.NET clients.
To set pass-through optimization for Oracle data source clients
1. Log into Studio as the admin user.
2. From the Administration menu, choose Configuration.
3. In the tree pane, navigate to Configuration > Data Sources > Oracle Sources > Performance.
4. If you are using a 6.1.0.1 JDBC client for this data source, leave Enable Pass Thru Optimizations set to true; otherwise, set it to false.
5. Click Apply.
6. Click OK.
7. Restart the TDV Server to implement any changes you have made.