Invention Grant
- Patent Title: Database performance tuning framework
-
Application No.: US15667405Application Date: 2017-08-02
-
Publication No.: US10915515B2Publication Date: 2021-02-09
- Inventor: Brent Bahry
- Applicant: ServiceNow, Inc.
- Applicant Address: US CA Santa Clara
- Assignee: ServiceNow, Inc.
- Current Assignee: ServiceNow, Inc.
- Current Assignee Address: US CA Santa Clara
- Agency: Fletcher Yoder PC
- Main IPC: G06F16/00
- IPC: G06F16/00 ; G06F16/22 ; G06F16/2458 ; G06F16/2453 ; G06F17/18

Abstract:
Techniques related to a database performance tuning framework are disclosed. The techniques include a system for improving performance of a database query, the system configured to generate one or more query execution time statistics relating to a database query operation performed by a database in response to a received query, store the query execution time statistics, determine the database query operation is slow based on the stored query execution time statistics, generate one or more database statistics based on the contents of the database, generate a suggested index using one or more of the generated database statistics, create the suggested index, determine another one or more query execution time statistics for the database query operation after creating the suggested index, and retain the suggested index based on a comparison of the stored query execution time statistics and the another query execution time statistics.
Public/Granted literature
- US20180322154A1 DATABASE PERFORMANCE TUNING FRAMEWORK Public/Granted day:2018-11-08
Information query