How can I improve performance of below query? It was running more than one hour to execute in my production environment. Query plan: mysql> explain SELECT transaction_detail.trans_id, ...
I have a transactions table which is having 600,000 records, I need to list the count for the dashboard on financial year basis. The table used is MyISAM. I tried adding index for the transaction date ...
I have two tables one for messages called default_messages and the other for recipients called default_recipient. This is how SQL for those table looks like: CREATE TABLE IF NOT EXISTS ...