How to do Statistics in Partial Indexes of PostgreSQL efficiently?
32378
Measure the size of a PostgreSQL table row
50612
SQL Server - how to determine if indexes aren't being used?
91217
Arbitrarily ordering records in a table
151620
Multidimensional indices in databases
93153
Optimizing SQL for large volumes
86649
What's the most efficient way to select the last n rows in a table without changing the table's structure?
35323
How do I get useful SQL Server database performance statistics?
28483
PostgreSQL Index Caching
99544
postgres: index to SELECT strings like '%foo%';
72586
MySQL: Fastest way to count number of rows
79228
With MySQL, how can I generate a column containing the record index in a table?
67337
Postgres: Reclaiming Space
11223
quick selection of a random row from a large table in mysql
96534
Efficiently select beginning and end of multiple contiguous ranges in Postgresql query
151821
Indexes: integer vs string performance if the number of nodes is the same
124308
Simulating MySQL's ORDER BY FIELD() in Postgresql
36725
MySQL - alternatives to nested subqueries when limiting aggregate data in a correlated subquery