Hello all,
I am executing the next select:
select name from table; and it is very quickly, but if i execute the next:
select * from table order by name; i need to wait hours.
I am doing the order by the PK. What can be the problem?, the table has 3000000 of fields and the db_block_size=2048
Thanks in advanced