Documentation Source Text

Check-in [b4f5fcc3c8]
Login

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
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: b4f5fcc3c82fe755c22392d7d46542ec5186e70f
User & Date: drh 2017-03-07 00:51:37.312
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
Unified Diff Ignore Whitespace Patch
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.