Techniques for optimization of inner queries
US10152511B2 · kind B2 · utility
14Cited by
70References
17Claims
0Family size
Assignee
Inventors
Key dates
| Filing date | Sep 16, 2013 |
| Grant date | Dec 11, 2018 |
| Priority date | — |
| Expiry date | Sep 30, 2034 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/2456
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
In an on demand database system, a query engine applies a custom index for inner queries. The query engine receives a query and determines that the query has an inner query nested within the primary query. The query engine identifies that a custom index exists for a client associated with the query, and applies the custom index to filter results for the query. The custom index includes a subset of information of a table that includes accounts for multiple different clients. By using the custom index, the query engine can filter the results more efficiently that if solely using the multiple client table.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.