= Database query
A <database query> requests information computed from stored data. It can filter <database tuples>, project selected <database attributes>, combine <database relations> or aggregate groups. For example, a query can return the count of orders per customer rather than retrieving every order separately. The query specifies a result; a <database query plan> chooses operations for computing it. Equivalent result specifications can have very different costs under different indexes and data sizes. In <SQL>, duplicate rows and null values require conventions beyond the simplest mathematical <relational algebra>.
Back to article page