SQL - Query (SELECT)

A query is a SQL statement that begins with the SELECT word.

A stored query is called a view.

The result of a query is stored in a result table, called the result-set.

A query is itself a Relations

• http://cosette.cs.washington.edu/ - Cosette is an automated prover for checking equivalences of SQL queries.

Ad-hoc queries are query used to explore a data set and are therefore never known in advance.

Reporting query are well-known query used to build metrics. See Data Analysis - Reporting Query

• Sql to relational algebra operator see Translating_SQL_to_Relational_Algebra

• pt-query-digest - Analyze MySQL queries from logs, processlist, and tcpdump
• http://www.tpc.org/tpcds/