Question : I am studying query optimization. I have read that it might be preferred to apply relational selections before […]
Category: Query Performance
Improve speed of stored proc with lots of inserts [Azure-SQL]
Question : Running an S0. @@version = Microsoft SQL Azure (RTM) – 12.0.2000.8 Jul 21 2017 14:10:34 Copyright (C) 2017 […]
Postgres is performing sequential scan instead of index scan
Question : I have a table with about 10 million rows in it and an index on a date field. […]
Monitoring Query which executes thousand of run/minute and is generally fast
Question : I am looking for some advise here on one of our SQL database server with below behavior- Queries […]
Why use both universal identifiers and separately incremented primary keys for strong entities?
Question : There is a good public example for this: The relational model of ChEMBL (A bioactive molecule database). Here […]
Best way to speed up requests using date columns
Question : Our database is receiving the following requests: select * from [schema].[table] (nolock) where (Date_A > Date_B and Archive […]
Oracle query optimization
Question : We have a query that runs on a view and its execution time is about 6 min. SELECT […]
Condense Query Results with Wildcard
Question : I have the following query: select programVersion, count(programVersion) from records R inner join Programs P on P.programID=R.usageProgramID where […]
Index or query tuning for complex predicates [closed]
Question : Closed. This question is off-topic. It is not currently accepting answers. Too localized – this could be because […]
SQL Server 2005 query with multiple conditions, some indexed, some not
Question : I have a table with 50 million rows. It is indexed on zip. A query Select * from […]