3 ms·
>There are hints you can use at CREATE time that are supposed to do the same thing, but they don't actually work in this particular case. Are you saying that "
by hackinthebochs 7y ago
>There are hints you can use at CREATE time that are supposed to do the same thing, but they don't actually work in this particular case.
Are you saying that "option(recompile)" doesn't work for you in this case? It works just fine for me when using that 'X is null or' pattern for optional filters.
- jasonkester 7y agoIndeed, that's the option I was testing that had no effect. From what I've read, it does seem to work in some cases. But not mine, sadly.
- hackinthebochs 7y agoWell that's interesting. I'll have to keep your little hack in the back of my mind. Thanks!