Hi, I have a million records in my DB. I tried using .explain on and ran the query below which took a long time although I just want the last 100,000 records...(It ran much faster when my table had a 100,000 records) so I assume it is related to how I constructed the statement.
select columns from myTable WHERE (rowid > (select max(rowid) from myTable) - 100000) and many more conditions group by myTable.column1, myTable.column2 explain just returned me the columns headers? Any pointers?