Thanks for the quick answer. This product is great! Bye!
Clodo <[EMAIL PROTECTED]> wrote:
But a changelogs say:
"Version 3.3.0 adds support for CHECK constraints, DESC indices, "
I use the 3.5.2 version.
What's the status/problem about that?
How i can re-write the first select above to u
--- [EMAIL PROTECTED] wrote:
> DESC indices requires a backwards-compatible file format
> changes. Older versions of SQLite (prior to 3.3.0) cannot
> read or write databases that make use of DESC indicdes.
> To preserve compatibility, SQLite generates databases in
> the old format by default. Th
Clodo <[EMAIL PROTECTED]> wrote:
>
> But a changelogs say:
> "Version 3.3.0 adds support for CHECK constraints, DESC indices, "
>
> I use the 3.5.2 version.
> What's the status/problem about that?
> How i can re-write the first select above to use an index on both fields?
> Thanks!
>
DESC i
Hi to all, i have a problem with indexes. For example:
CREATE TABLE T1 (
a text,
b text
);
CREATE INDEX I1 on T1 (a asc, b desc);
1' query:
explain query plan select * from t1 order by a asc, b desc limit 10
output detail-> TABLE T1
2' query:
explain query plan select * from t1 order by a as
4 matches
Mail list logo