Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Change the defined default mask for PRAGMA optimize to 0xfffe. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
b4f5fcc3c82fe755c22392d7d46542ec |
| User & Date: | drh 2017-03-07 00:51:37 |
Context
|
2017-03-07
| ||
| 13:08 | Merge the search form fix from the 3.17 branch. check-in: 4a748fb25c user: drh tags: trunk | |
| 00:51 | Change the defined default mask for PRAGMA optimize to 0xfffe. check-in: b4f5fcc3c8 user: drh tags: trunk | |
|
2017-03-06
| ||
| 23:14 | Fix typo in the pragma optimize documentation. check-in: f61736804d user: drh tags: trunk | |
Changes
Changes to pages/pragma.in.
961 962 963 964 965 966 967 968 969 970 971 972 973 974 975 976 977 978 |
information from the current session in the
database file so that it will be available to "optimize"
pragmas run by future database connections.
<li value='8'><p>
<em>(Not yet implemented)</em>
Create indexes that might have been helpful to recent queries.
</ol>
<p>The default MASK is 14 (0x0e), which means perform all of the optimizations
listed above except do not set Debug Mode. New optimizations may be
added in future releases but they will be turned off by default. The
default MASK will always be 0x0e.
<p><b>Determination Of When To Run Analyze</b></p>
<p> In the current implementation, a table is analyzed if only if all of
the following are true:
<ul>
<li><p>
MASK bit 0x02 is set.
|
| | | | > > > |
961 962 963 964 965 966 967 968 969 970 971 972 973 974 975 976 977 978 979 980 981 |
information from the current session in the
database file so that it will be available to "optimize"
pragmas run by future database connections.
<li value='8'><p>
<em>(Not yet implemented)</em>
Create indexes that might have been helpful to recent queries.
</ol>
<p>The default MASK is and alway shall be 0xfffe. The 0xfffe mask means
perform all of the optimizations listed above except Debug Mode. If new
optimizations are added in the future that should be off by default, those
new optimizations will be given a mask of 0x10000 or larger.</p>
<p>To see all optimizations that would have been done without actually
doing them, run "PRAGMA optimize(-1)".</p>
<p><b>Determination Of When To Run Analyze</b></p>
<p> In the current implementation, a table is analyzed if only if all of
the following are true:
<ul>
<li><p>
MASK bit 0x02 is set.
|