List of query hints?

Is there a comprehensive list of query hints that can be used in singlestore, and their purposes? For example, SELECT WITH(LEAF_PUSHDOWN=TRUE)? I see these appear in random forum threads and documents and I’d like to see what all is available for query tuning. Thanks!

Hi Erica. We don’t publish all our query hints, because we recommend them only as a last resort and some of them are experimental. It’s something we’ll consider for the future. If there is something specific you’re looking for, let me know.

Understood. I’m mostly experimenting right now but I will ask if I think of anything. Thank you!