Selecting a 80 million regs database ordered by an Index

[André Bandarra]

Hello.
I have a 80 million regs database and i want to make a select from it ordered by an index. But it takes forever to give me the result. I made a query like "create table ble (select * from table1 order by index)). I started the query yesterday and didn´t get a result until now. How should i create the index on the table so as to make a select from it ordered by the index??