diff options
| author | Bruce Momjian <bruce@momjian.us> | 1999-02-02 20:30:18 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 1999-02-02 20:30:18 +0000 |
| commit | f1b78234716bd639b045873c7be0c9424b897f16 (patch) | |
| tree | b5f1b8c0d004bf128c4bb5140879e7695d0e8054 /doc/src | |
| parent | eb3415538ec46f64ef66fb96203e7b2542b2111e (diff) | |
Make GEQO use dependent on table and index count.
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/ref/set.sgml | 7 |
1 files changed, 6 insertions, 1 deletions
diff --git a/doc/src/sgml/ref/set.sgml b/doc/src/sgml/ref/set.sgml index 9627c1f354c..ac3c225267a 100644 --- a/doc/src/sgml/ref/set.sgml +++ b/doc/src/sgml/ref/set.sgml @@ -406,7 +406,7 @@ SET TIME ZONE { '<REPLACEABLE CLASS="PARAMETER">timezone</REPLACEABLE>' | LOCAL </para> <para> This algorithm is on by default, which used GEQO for - statements of six or more tables. + statements of six or more tables and indexes. (See the chapter on GEQO in the Programmer's Guide for more information). </para> @@ -677,6 +677,11 @@ SET TIME ZONE { '<REPLACEABLE CLASS="PARAMETER">timezone</REPLACEABLE>' | LOCAL SET DATESTYLE TO 'ISO'; </programlisting> <programlisting> + --Enable GEQO for queries with 4 or more tables and indexes + -- + SET GEQO ON=4; + </programlisting> + <programlisting> --Set GEQO to default: -- SET GEQO = DEFAULT; |