Mike Yearwood
Toronto, Ontario, Canada
General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Hi Mike,
>WOW! OK, that's cool, but you didn't make the join expressions exactly match the index expressions. Made me wonder if there's any harm in doing so. It works fine.
>
As far as I know it is not necessary to modify WHERE clause because UDF arguments in a WHERE are always passed by value.
>Doesn't that exclude passing an array by reference to the UDF?
>
Yes, but that's the behavior that WHERE has, parameters are not passed by ref (see my answer above). So, if key expression passes parameter by ref, it doesn't match an expression in WHERE.
Thanks,
Aleksey.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only