The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Dec. 30, 2025
Filed:
Nov. 29, 2024
Microsoft Technology Licensing, Llc, Redmond, WA (US);
Smita Behera, Yarrow Point, WA (US);
Manish Eknath Tawade, Redmond, WA (US);
Derek Marcel Wilson, Chester, VA (US);
Irving Alfonso Covarrubias Martin Del Campo, Bellevue, WA (US);
Shitong Song, Guangzhou, CN;
In-Jerng Choe, Sammamish, WA (US);
Wai Keat Tan, Seattle, WA (US);
Patryk Maciej Uchman, Seattle, WA (US);
Adrian Catalin Dragusanu, Redmond, WA (US);
MICROSOFT TECHNOLOGY LICENSING, LLC, Redmond, WA (US);
Abstract
When two ad hoc query batches with the same query text are to be compiled, one locking key is created for both ad hoc query batches. The locking key is allocated to the first ad hoc query batch. In a subsequent cache lookup stage, if no cache is found for the first ad hoc query batch, a plan is compiled for the first ad hoc query batch, and inserted into a cache. The locking key is released and allocated to the second ad hoc query batch. If the locking key for the second ad hoc query batch is the same as for the first ad hoc query batch, the compiled plan is identified in the cache. Plan compilation is bypassed for the second ad hoc query batch.