Re: Unexplainable execution time difference between two test functions...one using IF (SELECT COUNT(*) FROM...) and the other using IF EXISTS (SELECT 1 FROM...)

On Tue, Apr 17, 2018 at 10:23 AM, Tomas Vondra wrote: > > > On 04/17/2018 04:01 PM, Hackety Man wrote: > >> >> >> On Tue, Apr 17, 2018 at 6:49 AM, Tomas Vondra < >> [email protected] <mailto:[email protected]>> >> wrot

Re: Unexplainable execution time difference between two test functions...one using IF (SELECT COUNT(*) FROM...) and the other using IF EXISTS (SELECT 1 FROM...)

Hi Pavel, Thanks for sharing that information. I was not aware that the parallel query functionality was not yet fully implemented. Thanks, Ryan On Tue, Apr 17, 2018 at 1:17 AM, Pavel Stehule wrote: > Hi > > 2018-04-16 22:42 GMT+02:00 Hackety Man : > >> *A description of w

Re: Unexplainable execution time difference between two test functions...one using IF (SELECT COUNT(*) FROM...) and the other using IF EXISTS (SELECT 1 FROM...)

On Tue, Apr 17, 2018 at 6:49 AM, Tomas Vondra wrote: > > > On 04/16/2018 10:42 PM, Hackety Man wrote: > >> ... >> The first thing I did was to run some baseline tests using the basic >> queries inside of the IF() checks found in each of the functions to &g

Unexplainable execution time difference between two test functions...one using IF (SELECT COUNT(*) FROM...) and the other using IF EXISTS (SELECT 1 FROM...)

*A description of what you are trying to achieve and what results you expect.:* My end goal was to test the execution time difference between using an IF(SELECT COUNT(*)...) and an IF EXISTS() when no indexes were used and when a string match was not found. My expectation was that my 2 functions