puzzled by date functions (long)

2006-03-01 Thread Giuseppe Maxia
Yesterday I was analyzing the behavior of the query optimizer, and I stumbled into a most curious case. I created two functions returning the extremes of a date range, and I wanted to see how many times those functions were called when used in a WHERE clause So I added log tracing instructions

Re: puzzled by date functions (long)

2006-03-01 Thread Dan Nelson
In the last episode (Mar 01), Giuseppe Maxia said: Yesterday I was analyzing the behavior of the query optimizer, and I stumbled into a most curious case. I created two functions returning the extremes of a date range, and I wanted to see how many times those functions were called when used in