Hi All, I have a sqlite database with single table with columns A, B and C. I have created composite primary key on A and B, and an autoindex was created (dont know on which columns this index is created).
When I fire select/delete query with WHERE clause on column A, it is completed in milliseconds, whereas when I fire the same kind of query on basis of columns B or C, it takes couple of minutes. What is causing this difference? A point to note: The table contains millions of rows. Thanks and Regards, Arjabh _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
