Caché Parameter File Reference
FastDistinct
[Back] [Next]
   
Server:docs1
Instance:LATEST
User:UnknownUser
 
-
Go to:
Search:    

Enable/disable SQL DISTINCT optimization.
Synopsis
[SQL]    FastDistinct=n
Description
The value n may be 1 or 0:
Examples
FastDistinct=1
Range of Values
0 or 1. The default is 1.
Management Portal
On the page System Administration > Configuration > SQL and Object Settings > General SQL Settings, for the DISTINCT optimization turned ON setting, choose Yes (true) or No (false).