[SalmaN97]

Quote:

Originally Posted by Calisthenics It is an expression in WHERE clause. [pawn] EDIT: Create a multi-column index. pawn Code: CREATE INDEX ownerid_indexindex ON attachments (ownerid, indexindex); https://www.sqlite.org/queryplanner....column_indices which will also work as a single-index for `ownerid` column.

thank you very much everything is fixed it works fine now but i would like to learn more about the Create a multi-column index. you talked about i checked the link i didnt understand can you please give me an example using my code above i will be grateful thanks