docs.intersystems.com
Home / Configuration Parameter File Reference / [SQL] / FastDistinct

Configuration Parameter File Reference
FastDistinct
Previous section           Next section
InterSystems: The power behind what matters   
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).


Previous section           Next section
Send us comments on this page
View this book as PDF   |  Download all PDFs
Copyright © 1997-2019 InterSystems Corporation, Cambridge, MA
Content Date/Time: 2019-05-21 07:39:07