Order By Clause, Slows Query Performance?

Поиск
Список
Период
Сортировка
От monalee_dba
Тема Order By Clause, Slows Query Performance?
Дата
Msg-id 1384069224632-5777633.post@n5.nabble.com
обсуждение исходный текст
Ответы Re: Order By Clause, Slows Query Performance?  (Michael Paquier <michael.paquier@gmail.com>)
Re: Order By Clause, Slows Query Performance?  (Albe Laurenz <laurenz.albe@wien.gv.at>)
Список pgsql-performance
Eg. SELECT col1, col2, col3,....col10 FROM table1;

For above query If I didn't mention ORDER BY clause, then I want to know
selected data will appear in which order by a query planner?

Because I have huge size table, and when I applied ORDER BY col1, col2..in
query the
performance is soo bad that I can't offred.
What should I do ? Because my requirement is data with ordered column.



--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Order-By-Clause-Slows-Query-Performance-tp5777633.html
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.


В списке pgsql-performance по дате отправления:

Предыдущее
От: monalee_dba
Дата:
Сообщение: BitMap Heap Scan & BitMap Index Scan
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: BitMap Heap Scan & BitMap Index Scan