Hi all !
in MySQL table index key which one is the right way ?
key (branch)
key (reference)
key (date)
select * from transaction where branch=?m.branch and reference=?m.ref and date=?m.date order by branch,reference,date
or
key (branch,reference,date)
select * from transaction where branch=?m.branch and reference=?m.ref and date=?m.date order by branch