Mike Yearwood
Toronto, Ontario, Canada
Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
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.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement