I found the following query in my slow query log, what can I do to make them better?
Your answer to this is very much appreciate.
1.Select * from filecategories where memberType = ? order by Sequence;
2.select count(*) from tbl_process WHERE (MVPCARDID like ?) AND (MYPLANID like ?);
3. select count(*) from tbl_process WHERE (MemberIDCard like ?);
4.select count(*) from tbl_process join tbl_flat_rs F1 on F1.plan_id = tbl_process.PlanID WHERE fn_subset(fld_210 , ?) AND ClientNumber <> ? AND (PartnersId = ?);