Optimize for Unknown hint

Description Beginning with 11.3.1 HF30, customers can now use the “Optimize for Unknown” SQL query hint on specific Catalog and Datamart tables. This query hint directs the SQL Query Optimizer to use execution plans that are based on statistical data instead of the variable values used in filters.
Impact Customers can enable this feature to expedite their query execution plans for specific Catalog and Datamart tables.
Related JTs JT-1339197
Related Documents Infor Business Vault Data Warehouse Designer Administrator Guide