MySQL Forums
Forum List  »  Performance

Selecting a 80 million regs database ordered by an Index
Posted by: André Bandarra
Date: December 16, 2004 11:21AM

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??

Options: ReplyQuote


Subject
Views
Written By
Posted
Selecting a 80 million regs database ordered by an Index
2719
December 16, 2004 11:21AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.