Question : I am looking for some advise here on one of our SQL database server with below behavior- Queries […]
Category: Query Performance
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 […]
Query performance low for aggregate function
Question : I perform a SUM query on a MySQL table of mine which takes around 1.5 seconds to complete. […]
OLTP – Stretch database vs linked server
Question : From my understanding, when you enable the StretchDB feature for a table, basically creates a Linked Server locally, […]
Access denied for user ‘root’@’localhost’ using Password NO
Question : I have enabled SQL SLOW LOG Queries in my.cnf file but i need to restart mysql and when […]