Invention Grant
- Patent Title: Index updates using parallel and hybrid execution
-
Application No.: US14326157Application Date: 2014-07-08
-
Publication No.: US09684684B2Publication Date: 2017-06-20
- Inventor: Srinivasan Mottupalli , Xiaobin Ma , Peter Schneider
- Applicant: Srinivasan Mottupalli , Xiaobin Ma , Peter Schneider
- Applicant Address: US CA Dublin
- Assignee: SYBASE, INC.
- Current Assignee: SYBASE, INC.
- Current Assignee Address: US CA Dublin
- Agency: Schwegman Lundberg & Woessner PA
- Main IPC: G06F17/30
- IPC: G06F17/30

Abstract:
A method can include receiving a request to execute a database command identifying a target table; identifying a plurality of rows to insert into the target table based in part on the database command; writing rows, from the plurality of rows, into a data page until the data page is full; determining, by an index thread manager, a number of threads to use for updating indexes defined for the target table; and upon determining the data page is full, updating, in parallel, the indexes defined for the target table using the number of threads.
Public/Granted literature
- US20160012083A1 INDEX UPDATES USING PARALLEL AND HYBRID EXECUTION Public/Granted day:2016-01-14
Information query