Hi, It's great!
The slide show from the PHP conference explains that SELSCT .. ORDER BY uses indice (if possible) for sorting, so this is the expected behaviour. I was not expecting it because in ORACLE it is not so: SELSCT .. ORDER BY does't use indexes for sorting in most cases. May be in order to prevent expences of additional disc operations of index reading... Thanx, Serge Liber > The slide show from the PHP conference gives a good > explanation of how indices are used, starting around > slide 40 or 50. It's linked from the main SQLite web > page. > > Regards
