wow, this "option (optimize for unknown)" really is like magical fairy dust. It took an 8s query (bad query plan! BAD!) down to 50ms.