Hi Anna,
Result wise all three options are same, only differs in perfermance
True A option is the best, other two will degrade the performance,
Optimizer need to convert the given value to datetime.
Some time optimizer is cleaver enough to implitly convert the value to datetime
Saferside please prefer option A.
Thanks
Saravana Kumar C
No comments:
Post a Comment