Peer To Patent

View Prior Art for Claim 00001

A method implemented on a general-purpose computing device for discovering and expressing query hints in a database management system, comprising:using the general-purpose computing device to perform the following:input a query having an initial query execution plan;

computing a direct acyclic graph for the query;

constraining the query using a power hints query language expression;

computing candidate matches for each operator in the initial execution plan;

extracting a revised query execution plan having a lowest cost as determined by a query optimizer cost model that satisfies constraints of the power hints query language expression;

displaying the revised query execution plan in a graphical manner to a user; and

allowing the user to change the revised query execution plan if the user is not satisfied with the revised query execution plan.

#627'Oracle® Database Performance Tuning Guide': Using Optimizer Hints

Applies to Claims 1,14

Submitted by: Diane WillisLast updated: over 2 years ago

Title Oracle® Database Performance Tuning Guide

Description

'Optimizer hints can be used with SQL statements to alter execution plans.'

0 thumbs up 0 thumbs down

View Full Prior Art >

Annotations(0)

#629DB2 Version 9 for Linux, UNIX, and Windows: Optimizer profiles and guidelines overview

Applies to Claims 1,14

Submitted by: Diane WillisLast updated: over 2 years ago

Title DB2 Version 9 for Linux, UNIX, and Windows Optimizer profiles and guidelines overview

Description

Information on the DB2 Optimizer and the ability of the DB2 data base administrator to modify the execution plan for better data base performance.

0 thumbs up 0 thumbs down

View Full Prior Art >

Annotations(1)