Re: [SQL] can't get rid of unnesesary SORT step in explain plan for hash join

On Sun, 13 May 2001, Tom Lane wrote: > Alexey Nalbat <[EMAIL PROTECTED]> writes: > > So, my question is: how can I get rid of this unnesesary "Sort" step > > in the execution plan for hash join? > > You can't, because it's not unnecessary. Hash j

[SQL] can't get rid of unnesesary SORT step in explain plan for hash join

que (cost=0.00..90.75 rows=1 width=16) -> Nested Loop (cost=0.00..90.74 rows=1 width=16) -> Index Scan using products_mcr on products (cost=0.00..8.14 rows=10 width=12) -> Index Scan using resellers_n on resellers (cost=0.00..8.14 rows=10 width=4) -- WBR, Alexey Nalbat ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl