Top "Sql-tuning" questions

How to find out why the status of a spid is suspended? What resources the spid is waiting for?

I run EXEC sp_who2 78 and I get the following results: How can I find why its status is suspended? …

sql sql-server optimization query-optimization sql-tuning

Oracle 11g high IO Wait

Oracle Version: 11.1.0.7.0 We are having higher IO Wait in one of our Oracle RAC instance One SQL is having high …

performance oracle11g sql-tuning iowait

SQL Server audit logout creates huge number of reads

I'm using SQL Server Profiler to figure out what process are consuming SQL process and I found that the event …

sql sql-server sql-server-2008 database-tuning sql-tuning

What is the meaning of Cost, Cardinality and Bytes in Explain Plan?

This is a simple query: select * from customers When I write this query in PL/SQL Developer and press F5, …

oracle plsqldeveloper sql-tuning

SELECT clause using IN ... very slow?

Could you guys please review the following query to an Oracle DB and point out what's wrong: SELECT t1.name …

sql oracle sqlperformance sql-tuning

Why does PostgresQL query performance drop over time, but restored when rebuilding index

According to this page in the manual, indexes don't need to be maintained. However, we are running with a PostgresQL …

performance postgresql indexing sql-tuning

Performance issue with inline view in Oracle

I have a query that looks like below and the tables A,T,S have around 1 million rows whereas P …

performance oracle sql-tuning inline-view