METHOD FOR IDENTIFYING FUNCTIONAL AND PERFORMANCE RELATED ISSUES CAUSED BY USING WRONG DATABASE HINTS

摘要

The present invention discloses system, method and apparatus for identifying functional and performance related issues by using database hints. In one implementation, a method for query execution using hints in a database management system is disclosed. The method comprises receiving at least one query; determining at least one functional and/or performance related issues for at least one hint selected for execution of the query received; identifying at least one hint rule from a set of pre-defined hint rules to repair functional and/or performance related issues determined in the hint selected for the query; recommending at least one corrective hint to execute the query based on the hint rule identified to repair the functional and/or performance related issues; and executing the query received using the corrective hint recommended. (TO BE PUBLISHED WITH FIGURES 3 & 4)