Quick Links

Re: SELECT ... WHERE ... IN (SELECT ...) ->

From:	Sergey Suleymanov <solt(at)eatpbank(dot)ru>
To:	Russian PostgreSQL community <pgsql-ru-general(at)postgresql(dot)org>
Subject:	Re: SELECT ... WHERE ... IN (SELECT ...) ->
Date:	2006-12-05 07:59:47
Message-ID:	873b7u22oc.fsf@su.eatpbank.ru
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-ru-general

>>>>> Alexander M Pravking writes:

Alexander> IMHO, этот индекс вообще лишний. Можно попробовать снести,
Alexander> и у оптимизатора не останется ничего другого, кроме как
Alexander> использовать индекс по login_id.

И толку? Потом ведь еще надо сортировку order by отработать.

--
Sergey Suleymanov

In response to

Re: SELECT ... WHERE ... IN (SELECT ...) -> at 2006-12-05 07:37:41 from Alexander M. Pravking

Responses

Re: SELECT ... WHERE ... IN (SELECT ...) -> at 2006-12-05 08:07:29 from Anton

Browse pgsql-ru-general by date

	From	Date	Subject
Next Message	Anton	2006-12-05 08:07:29	Re: SELECT ... WHERE ... IN (SELECT ...) ->
Previous Message	Alexander M. Pravking	2006-12-05 07:37:41	Re: SELECT ... WHERE ... IN (SELECT ...) ->