Dear All,
I have a table which has 300 columns and keeps records 60,00,000 at this time. Records are increasing day by day. When I run a simple query like:
select * from table where store_no = 17
this query takes 30 to 60 seconds for fetching the data against this query which is to much time, while I'll use this table with more filters. Can anyone help me that hcow i can increase data fetching performance, i have also used a primary key indexing.
Regards,
Shahab