let say I have two tables like
tbl_children (just as an example), in the first table I have
parent_id, and in the second one I (will) have something like
child_id plus the
parent_id, plus some other columns.
My question is does it make any sense to make the database columns in
parent_id first, following by
child_id? Because I will
index them, and my
WHERE clause should be some thing like
WHERE parent_id = x AND child_id = y.
Again this is just an example. I just want to know if column orders could improve the performance on indexed columns or not?
Platform: MySQL, InnoDB, on Integer Values.