Viewing 10 posts - 1 through 10 (of 10 total)
Hi Antoon Vansina,
I found the solution just a minutes before you post the link which includes the solution!
It now works like a charm.
if you want any help let me know.
Thanks,
July 26, 2005 at 6:24 am
Ten Centuries
I think you did not read what i wrote!
"The plan is created B4 the execution" ok
"The plan also has to work for all possible values of the parameters"...
May 5, 2005 at 12:20 am
Dear Grasshopper,
Appreciating all what you mentioned, it’s all correct, BUT...
My friend: The part “OR @x = -1” is being evaluated for each row in the table! The optimizer should...
May 4, 2005 at 9:21 am
Dear Grasshopper,
Appreciating all what you mentioned, it’s all correct, BUT...
My friend: The part “OR @x = -1” is being evaluated for each row in the table! The optimizer should...
May 4, 2005 at 9:21 am
i agree with you. but what if you have a query where you have 15 filtering condtions! you will have too many if conds in your code!
if you have condtions:...
April 30, 2005 at 5:37 am
Two examples are 100% equivilant in case you send value other than -1. see in my example i am sending 2 as a values and the returned dataset is only...
April 30, 2005 at 5:34 am
its a bad behaviour! scanning the table searching nothing! do you agree?
April 30, 2005 at 5:29 am
That link was exactly what I was searching for, you heal my breast man.Thanks a million.
October 5, 2004 at 6:39 am
Viewing 10 posts - 1 through 10 (of 10 total)