Invention Grant
- Patent Title: Automated database query tuning
-
Application No.: US15295256Application Date: 2016-10-17
-
Publication No.: US10762085B2Publication Date: 2020-09-01
- Inventor: Awais Tariq , Rohitashva Mathur , Arup Dutta , Prem Veeramani , Jesse Collins
- Applicant: salesforce.com, inc.
- Applicant Address: US CA San Francisco
- Assignee: salesforce.com, inc.
- Current Assignee: salesforce.com, inc.
- Current Assignee Address: US CA San Francisco
- Agency: Jaffery Watson Mendonsa & Hamilton LLP
- Main IPC: G06F7/00
- IPC: G06F7/00 ; G06F16/2453 ; G06F16/21 ; G06F16/22 ; G06F16/2457 ; G06F17/00

Abstract:
Automated query tuning. A database query to be executed against a database is received. The database query is analyzed to determine one or more potential indexes to be evaluated. The one or more potential indexes are evaluated to determine if an optimization utilizing a selected potential index provides improved performance over performing the database query without the selected potential index. The one or more potential indexes are scored based on results of the evaluating. A recommendation of one or more of the potential indexes is provided to a source of the database query.
Public/Granted literature
- US20180107714A1 AUTOMATED DATABASE QUERY TUNING Public/Granted day:2018-04-19
Information query