Question : Closed. This question is off-topic. It is not currently accepting answers. Tip of the iceberg – the question […]
Category: Performance
Does joining to the same table twice have a predictable performance impact
Question : I have a simple dimension, for example a date dimension, which is static and unchanging over time. In […]
The implications of lack on indexes on supporting a large production database
Question : The situation is as follows: I started at a new company several months ago in a support capacity. […]
Different execution plan with Rownum
Question : I have a query like this: select * from (select ecards0_.CDMAINAPPTYP , . . . ecards0_.CDISSUMTHD as col_23_0_ […]
MySQL query ‘going away’ on executing INSERT ON DUPLICATE UPDATE statement with a 12524 character blob
Question : I have a mysql insert on update query like so insert into table (col1, col2, col3) values (1,2,’huge […]
Delete duplicate records with no change in between
Question : I have a products table where I insert around 150,000 records a day. Most of them are redundant, […]
Would a date clustered index speed up queries with date ranges? (SQL Server) [closed]
Question : Closed. This question needs to be more focused. It is not currently accepting answers. Want to improve this […]
How to get SEEK accessing converted ID via view
Question : Assume I have a table: — just for test purposes CREATE TABLE SomeTable ( ID INT IDENTITY(1,1) NOT […]
How do I use subquery on the same table in MySQL?
Question : I have a query like this which takes a really long time to run. The table is around […]
In SQL Server, what are the typical symptoms of parameter sniffing?
Question : There is a wealth of information on the DBA.SE about what parameter sniffing is and how it relates […]