ALEXANDRIA, Va., Dec. 2 -- United States Patent no. 12,488,001, issued on Dec. 2, was assigned to Snowflake Inc. (Bozeman, Mont.).
"Rule based hint application" was invented by Sangyong Hwang (Sammamish, Wash.), Sourav Sikdar (Houston) and Li Yan (Redmond, Wash.).
According to the abstract* released by the U.S. Patent & Trademark Office: "The subject technology receives a first query plan corresponding to a query, the first query plan comprising a set of join nodes, and a join order hint of a target query plan, each join node of the target query plan associated with a hint. The subject technology generates a second query plan to correct a set of vertical positions of a set of terminal nodes of the first query plan following the join order...