This is my first posting so if I miss any relevant info please just ask for more detail.
I am converting an Oracle 8i db to MySQL. The problem I am having is that the oracle db used indexed tables e.g.
create table genre (
id numeric primary key,
From what I have read of Oracle this is an Index Organized Table, which I have never heard of before. I read a little on the Oracle web site but not being a db admin there was much I didn't understand.
I want to transpose this to a MySQL db but am unsure how to index the tables in the way specified in the Oracle db table.