In the documentation below under the Pragmas section there seems to be a hint
that I can create a temporary index.
However the CREATE INDEX syntax does not allow the word TEMPORARY to be used.
Anyone know what is going on?
Clive
PRAGMA temp_store;
PRAGMA temp_store = DEFAULT; (0)
PRAGMA temp_store = FILE; (1)
PRAGMA temp_store = MEMORY; (2)
Query or change the setting of the "temp_store" parameter. When temp_store is
DEFAULT (0), the compile-time C preprocessor macro
TEMP_STORE is used to determine where temporary tables and indices are stored.
When temp_store is MEMORY (2) temporary tables
and indices are kept in memory.
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
