When optimizing complex queries, it's important to analyze and tune both the SQL ____________ and the database schema.

  • Statements
  • Indexes
  • Triggers
  • Views
The correct option is Statements. Optimizing complex queries involves analyzing and tuning the SQL statements themselves to ensure they're written efficiently. Additionally, tuning the database schema, including indexes, triggers, and views, is necessary to enhance query performance.
Add your answer
Loading...

Leave a comment

Your email address will not be published. Required fields are marked *