How can I improve performance of a materialized view with order by clause?
I've created a materialized view with ~57 million rows. When I query using an order by, it takes ~12 seconds, but without an order by, it takes 200msec. Is there anything I can do to improve performance when using it?
