Missing database indexes and unoptimized queries cause severe production slowdowns

slow running queries... most common symptom is what we will say is whenever you try to debug the query... if stats are out outdated then query will start giving you... optimizer will generate a bad plans... the data has been grow and now whatever the index... it is not actually working

Other common mistakes include missing database indexes on columns you frequently cury, fetching entire tables when you only need 10 rows, and not using connection pooling. So your app creates new database connection on every request. You might think your queries are fast because they work fine in development with 100 rows of test data, but in production with 50,000 rows and no indexes, that same query takes 3 seconds instead of 30 milliseconds.