Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Tue, 05 Dec 2006 11:10:49 +0300
- Message-id: <87k616zrsm(dot)fsf(at)su(dot)eatpbank(dot)ru>
>>>>> Anton writes:
>> А если таки явно нарисовать join ?
Anton> то ничего не меняется, т.к. оно как раз это вроде бы само-то и
Anton> делает.
Тогда остается только разнести order by от join
select collect_time
from (select collect_time
from n_logins
join n_traffic on (n_traffic.login_id = n_logins.login_id and
n_traffic.collect_time > '1970-01-01 00:00:00')
where n_logins.account_id = '1655' ) as q
order by collect_time limit 1
и индекс по (login_id,collect_time)
--
Sergey Suleymanov
- References:
- SELECT ... WHERE ... IN (SELECT ...) -> SELECT ... WHERE (... OR ... )
- From: Anton
- Re: SELECT ... WHERE ... IN (SELECT ...) -> SELECT
- From: Teodor Sigaev
- SELECT ... WHERE ... IN (SELECT ...) -> SELECT ... WHERE (... OR ... )
- From: Anton
- Re: SELECT ... WHERE ... IN (SELECT ...) -> SELECT
- From: Teodor Sigaev
- Re: SELECT ... WHERE ... IN (SELECT ...) -> SELECT ... WHERE (... OR ... )
- From: Anton
- Re: SELECT ... WHERE ... IN (SELECT ...) ->
- From: Sergey Suleymanov
- Re: SELECT ... WHERE ... IN (SELECT ...) ->
- From: Anton
- SELECT ... WHERE ... IN (SELECT ...) -> SELECT ... WHERE (... OR ... )
- Prev by Date: Re: SELECT ... WHERE ... IN (SELECT ...) ->
- Next by Date: Re: SELECT ... WHERE ... IN (SELECT ...) -> SELECT ... WHERE (... OR ... )
- Previous by thread: Re: SELECT ... WHERE ... IN (SELECT ...) ->
- Next by thread: Re: SELECT ... WHERE ... IN (SELECT ...) -> SELECT ... WHERE (... OR ... )
- Indexes: