"orefkov" <[EMAIL PROTECTED]> wrote: > Hi All. > > When I used "+" for avoiding using indexes in "order by" list, > this cause a duplicate columns in ephemeral "sort" table. > > Example: > > "select col1, col2, sum(col3) from ttab group by +col1, col2" > > In this case, ephemeral table contain 5 columns, where column 0 and 3 are > duplicate: > > 25 Column 0 0 # ttab.col1 > 26 Column 0 1 # ttab.col2 > 27 Sequence 1 0 > 28 Column 0 0 # ttab.col1 > 29 Column 0 2 # ttab.col3 > 30 MakeRecord 5 0 > 31 IdxInsert 1 0 > > How I can force SQLite don't use index on grouping, and don't add duplicate > column in ephemeral table? >
You can't. Why are you trying to avoid the use of indices? Most people like it when their indices make an ORDER BY go faster. And why are you worried about duplicate data in a transient table, as long as you are getting the correct answer? -- D. Richard Hipp <[EMAIL PROTECTED]> ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
