Re: Query slows when used with view

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: Query slows when used with view
Дата
Msg-id CAMkU=1xgK1pWKFssxOW8unAhvJdA6ub_xcFcCNzUdBGGQKOEYA@mail.gmail.com
обсуждение исходный текст
Ответ на RE: Query slows when used with view  (Yavuz Selim Sertoğlu (ETIYA)<yavuz.sertoglu@etiya.com>)
Ответы Re: Query slows when used with view
Список pgsql-performance


On Wed, Oct 9, 2019 at 10:56 AM Yavuz Selim Sertoğlu (ETIYA) <yavuz.sertoglu@etiya.com> wrote:
Thanks for the reply Tom,

Sorry, I couldn't understand. I just copied inside of view and add conditions from query that runs with view.
The comma parts are the same in two queries, one is inside of view the other is in the query.

When you join to a view, the view sticks together, as if they were all in parentheses.   But when you substitute the text of a view into another query, then they are all on the same level and can be parsed differently.

Consider the difference between "1+1 * 3", and "(1+1) * 3"

Cheers,

Jeff

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

Предыдущее
От: Michael Lewis
Дата:
Сообщение: Re: Query slows when used with view
Следующее
От: Michael Lewis
Дата:
Сообщение: Re: Query slows when used with view