Explain the concept of query optimization in the context of BI analytics. How do indexes, query plans, and table partitioning improve performance?

Sample answer preview

Query optimization is critical for BI analysts because analytical queries often scan large tables and perform complex calculations. Understanding how the database processes queries helps you write efficient SQL and design data structures that support fast reporting.