Just wondering where is the index info physically located in MySQL database if I have indexed a table with
ALTER TABLE contacts ADD KEY (columnName); ?
- it will stay with that table and add a new spacial column to it;
- stay separately from that table;
I think the #2 is the correct answer.
Can we index columns from more than one tables? how?