Hi, Could someone please explain me how temporary indexes work ?
I have tried the query "CREATE TEMP INDEX tmpidx ON table(field)" without success. Same thing if the table is also temporary itself. Same thing with TEMPORARY UNIQUE indexes and same thing when I use TEMP instead of TEMPORARY. The error I get is : 'near "INDEX": syntax error' The query works fine when I remove TEMP. Is this feature disabled ? Do I have to enable it at compile time ? I am using 2.8.11 on Mac OS X. Thanks for your help, Bertrand Mansion Mamasam --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
