[sqlite] where all indexing is used?

[B V, Phanisekhar]

Assume a table

 

            "create table if not exists Title (Id INTEGER PRIMARY KEY,
Titlename BLOB)"

 

"create unique index if not exists TitleIdx ON Title (Titlename)"

 

For which all queries index "TitleIdx" will be used?

 

*         select Titlename from Title order by Titlename

*         select Titlename from Title where id in (...) order by
Titlename

*         select Titlename from Title order by Titlename limit = 3
offset = 10

 

Regards,

Phani