2
votes
The implications of lack on indexes on supporting a large production database
Typically it's a good idea to index on the fields in the predicates (JOIN, WHERE, and HAVING clauses) of the queries commonly executed on your server or the queries that require executing with the ...
1
vote
The implications of lack on indexes on supporting a large production database
As J.D. has mentioned indexes (or lack of) can have a significant impact on query level performance and it certainly warrants further investigation. In a nutshell the more that SQL can efficiently use ...
Only top scored, non community-wiki answers of a minimum length are eligible
Related Tags
performance × 6259query-performance × 2101
sql-server × 2017
mysql × 1718
postgresql × 1265
optimization × 611
index × 583
performance-tuning × 448
postgresql-performance × 446
database-design × 332
execution-plan × 308
oracle × 299
sql-server-2012 × 276
innodb × 250
sql-server-2008-r2 × 219
sql-server-2008 × 211
join × 198
index-tuning × 196
sql-server-2014 × 170
sql-server-2016 × 162
t-sql × 151
mariadb × 114
sql-server-2005 × 112
mysql-5.5 × 108
partitioning × 95