Group by's in materialized views and query planning
135418
What factors go into an Indexed View's Clustered Index being selected?
146399
Database design for products with bundles of products
110490
How to mimic a full outer join using mysql views?
73090
Execution sequence of Group By, Having and Where clause in SQL Server?
138361
What's faster, SELECT DISTINCT or GROUP BY in MySQL?
93153
Optimizing SQL for large volumes
77288
many-to-many relationship in database design
156237
Efficient query to get greatest value per group from big table
69565
Finding contiguous ranges in grouped data
113286
Get top n records for each group of grouped results
152806
When should you consider indexing your sql tables?
104418
A QuerySet by aggregate field value
7999
MySQL: View with Subquery in the FROM Clause Limitation
67785
Creating duplicate features based on many-to-one conversion of related table?
155875
Oracle: How can I implement a "natural" order-by in a SQL query?
42922
Database modeling for international and multilingual purposes
102054
Is there an Oracle SQL query that aggregates multiple rows into one row?