Re: optimize the query

[ch srinivas]

Thanks for reply

but we have indexs on those columns then also it getting slow

select column_name,index_name from information_schema.STATISTICS where table_schema='MasterDB' and table_name='MDB_ModelVariables';
+-------------+------------+
| column_name | index_name |
+-------------+------------+
| LeadID | PRIMARY |
| MD4_FPD3 | MD4_FPD3 |
| newcustid | newcustid |
| ObsDate | ObsDate |
+-------------+------------+
select column_name,index_name from information_schema.STATISTICS where table_schema='uklmodels' and table_name='BehaviourModel';
+-------------+------------+
| column_name | index_name |
+-------------+------------+
| NewCustId | NewCustId |
| ObsDate | ObsDate |
+-------------+------------+
please give me reply