Re: Forcing use of indexes
От
Tom Lane
Тема
Re: Forcing use of indexes
Дата
Msg-id
21230.1049297795@sss.pgh.pa.us
Ответ на
Re: Forcing use of indexes (Pedro Alves)
Список
Дерево обсуждения
Forcing use of indexes Pedro Alves <pmalves@think.pt>
Re: Forcing use of indexes Tom Lane <tgl@sss.pgh.pa.us>
Re: Forcing use of indexes Pedro Alves <pmalves@think.pt>
Re: Forcing use of indexes Tom Lane <tgl@sss.pgh.pa.us>
Re: Forcing use of indexes Lincoln Yeoh <lyeoh@pop.jaring.my>
Re: Forcing use of indexes Tom Lane <tgl@sss.pgh.pa.us>
Pedro Alves writes: > On Wed, Apr 02, 2003 at 09:52:19AM -0500, Tom Lane wrote: >> Presently, you'd need an index on (bar,foo) to get a good plan for a >> query expressed that way. > Thats what I meant when I said 'I have a composite index in columns foo > and bar'. In the second query, it doesn't this index. An index on (foo,bar) isn't equivalent to one on (bar,foo). regards, tom lane
В списке pgsql-general по дате отправления
