Question : I have two tables that temporarily hold uploaded data from a web application before it gets processed. This […]
Category: Query Performance
Speed up query execution. Can we add an index or rewrite the query
Question : I’ve been working on this query handed to me by a developer who wanted to reduce the query […]
Query not showing in dba_hist_active_sess_history
Question : The application team claims there was a statement that took about 30s to execute at about a certain […]
Is it possible to change between SELECT column based on an “IF” statement? and use INNER JOIN variables?
Question : I have a table of ‘mapped_products’: product_id | price A table of ‘product_id_to_name’: product_id | product_name (please don’t […]
SQL Server – how can a select be so slow [closed]
Question : Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? […]
Viewing execution plans for queries with parameters
Question : I have a sample query generated by an application (Microsoft Dynamics AX 2012 in this case) which is […]
How to Speed Up my SQL Query?
Question : I have a query that is taking much longer than I expect it should, and I can not […]
how to find out the `Key Lookups` in the current query plan?
Question : I am putting a query to list the key lookups that are present in the current requests being […]
How much performance difference could be assumed from an XAMPP server to a real Server [closed]
Question : Closed. This question needs to be more focused. It is not currently accepting answers. Want to improve this […]
What can speed up a SQL count query?
Question : When doing a count (aggregate) SQL query, what can speed up the execution time in these 3 database […]