Class QueryAnalyzer

java.lang.Object

com.loomcache.server.query.QueryAnalyzer

public class QueryAnalyzer
extends Object

Analyzes SQL queries to identify optimization opportunities and potential issues. Provides warnings, suggested indexes, and query plan analysis.

Nested Class Summary

Nested Classes

Modifier and Type	Class	Description
static final record	QueryAnalyzer.QueryAnalysis	Analysis result for a query.

Constructor Summary

Constructors

Constructor	Description
QueryAnalyzer()

Method Summary

Modifier and Type	Method	Description
QueryAnalyzer.QueryAnalysis	analyzeQuery(String sql)	Analyzes a SQL query and returns optimization suggestions.
String	explainQuery(String sql)	Returns an EXPLAIN-like plan for a query without executing it.

Methods inherited from class Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details

QueryAnalyzer

public QueryAnalyzer()

Method Details

analyzeQuery

public QueryAnalyzer.QueryAnalysis analyzeQuery(String sql)

Analyzes a SQL query and returns optimization suggestions.

Parameters:

sql - the SQL query to analyze

Returns:

QueryAnalysis with cost, indexes, warnings, and hints

explainQuery

public String explainQuery(String sql)

Returns an EXPLAIN-like plan for a query without executing it.

Parameters:

sql - the SQL query

Returns:

a string representation of the query plan