Here is my table :
In my table
Clustering_key(Primary key and auto incremental)
Data(Text datatype column)
Position(Index column) maintain the order of
My table have 90,000 rows with same
ID equal to 5. I want to fetch first 3 rows and my query like this
Select * from mytable where ID=5 Limit 3;
ID column is index column So I think mysql scan only first 3 rows but mysql scan around 42000 rows.
Here Explain query :
Any possibility to avoid all rows scan.
Please give me some solution
Thanks in advance