В сообщении от Tuesday 01 July 2008 23:47:50 [EMAIL PROTECTED] написал(а): > On Tue, 1 Jul 2008, Alexey Pechnikov wrote: > > Is any difference between "CREATE INDEX ev_idx ON events(type,eid)" > > and "CREATE INDEX ev_idx ON events(type,eid desc)"? What is "desc" > > keyword for index? > > The DESC keyword creates the index in descending collation order, rather > than ascending order (default). I believe this sort order may not be > observed in older versions, but more recent ones do so.
I'm using SQLite 3.5.9 and there are no differents in my tests between DESC and default indeces. I try create index with keywork DESC for optimize DESC sorting but it don't work for me. My tests you can see above. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users