Function countSubqueries

pkg/advisor/optimizer.go:266–288

countSubqueries recursively counts subquery expressions in an expression tree.

(expr ast.Expression)

// countSubqueries recursively counts subquery expressions in an expression tree.
func countSubqueries(expr ast.Expression) int {
	if expr == nil {
		return 0
	}

	count := 0

	switch e := expr.(type) {
	case *ast.SubqueryExpression:
		count++
	case *ast.InExpression:
		if e.Subquery != nil {
			count++
		}
	case *ast.ExistsExpression:
		count++
	case *ast.BinaryExpression:
		count += countSubqueries(e.Left)
		count += countSubqueries(e.Right)
	}

	return count
}

// calculateScore computes the optimization score (0-100).
// Each suggestion reduces the score based on its severity.