US 12,346,300 B2
Automated real-time index management
Mohamed Zait, San Jose, CA (US); Sunil Chakkappen, Foster City, CA (US); Christoforus Widodo, Sunnyvale, CA (US); and Zhan Li, Redwood Shores, CA (US)
Assigned to ORACLE INTERNATIONAL CORPORATION, Redwood Shores, CA (US)
Filed by Oracle International Corporation, Redwood Shores, CA (US)
Filed on Jun. 9, 2021, as Appl. No. 17/343,659.
Application 17/343,659 is a continuation of application No. 16/248,479, filed on Jan. 15, 2019, granted, now 11,068,460.
Claims priority of provisional application 62/748,457, filed on Oct. 20, 2018.
Claims priority of provisional application 62/715,263, filed on Aug. 6, 2018.
Prior Publication US 2021/0303539 A1, Sep. 30, 2021
This patent is subject to a terminal disclaimer.
Int. Cl. G06F 16/00 (2019.01); G06F 16/22 (2019.01)
CPC G06F 16/2272 (2019.01) 18 Claims
OG exemplary drawing
 
1. A method, comprising:
a database management system (DBMS) selecting a working set of queries by monitoring queries that are executed by said DBMS;
monitoring column usage of said working set of queries, wherein said column usage includes use of a column in one or more of a filtering predicate, a join predicate, a group-by operation, and an order-by operation by said set of working queries;
based on said column usage, selecting a certain set of one or more auto indexes;
making said certain set of one or more auto indexes available for executing queries not in said working set of queries; and
after making said certain set of one or more auto indexes available:
performing one or more executions of a particular query, each execution of said one or more executions using a particular auto index of said certain set of one or more auto indexes; and
based on execution performance of said one or more executions, locking down said particular auto index for said particular query.