subject:"\[GENERAL\] hard parse\?"

Re: [GENERAL] hard parse?

2017-09-21 Thread Tom Lane

"David G. Johnston" writes: > On Thu, Sep 21, 2017 at 5:48 AM, Peter Koukoulis > wrote: >> I have a query where a filter would always be negative, how many steps, >> out these: >> >> - parsing and syntax check >> - semantic analysis >> -

Re: [GENERAL] hard parse?

2017-09-21 Thread David G. Johnston

On Thu, Sep 21, 2017 at 5:48 AM, Peter Koukoulis wrote: > Hi > > I have a query where a filter would always be negative, how many steps, > out these: > >- parsing and syntax check >- semantic analysis >- transformation process (query rewrite based on system or >

[GENERAL] hard parse?

2017-09-21 Thread Peter Koukoulis

Hi I have a query where a filter would always be negative, how many steps, out these: - parsing and syntax check - semantic analysis - transformation process (query rewrite based on system or user-defined rules) - query optimization - execution would be performed or not? Also,