Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | The optimizer now uses only the index and ignores the table if it can get away with doing so, thus saving a single BTree search per row of result. This could potentially double the speed of certain queries. The code passes all regression tests but new tests to exercise the new functionality are yet to be added. (CVS 2170) |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
e5aa489453bf31126da6473ef93c89ec |
| User & Date: | drh 2004-12-19 00:11:35 |
Context
|
2004-12-20
| ||
| 19:01 | Add PRAGMA 'temp_store_directory'. Added os_*.c function sqlite3OsIsDirWritable(), split pragma.c changeTempStorage() function into invalidateTempStorage(). (CVS 2171) (check-in: 772e22cb user: tpoindex tags: trunk) | |
|
2004-12-19
| ||
| 00:11 | The optimizer now uses only the index and ignores the table if it can get away with doing so, thus saving a single BTree search per row of result. This could potentially double the speed of certain queries. The code passes all regression tests but new tests to exercise the new functionality are yet to be added. (CVS 2170) (check-in: e5aa4894 user: drh tags: trunk) | |
|
2004-12-18
| ||
| 18:40 | Improvements to the query optimizer. This is a work in progress. (CVS 2169) (check-in: 9b86993f user: drh tags: trunk) | |
Changes
Changes to src/sqliteInt.h.
Changes to src/vdbe.c.
Changes to src/where.c.
Changes to test/collate4.test.
Changes to test/where.test.