Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in sql-tuning

Query Tuning - Advice

Using Oracle build-in UPPER function in WHERE lead to bad performance of SELECT statement?

Oracle: hugely improve query performance

Is using OR clause in MySQL SELECT statement a generally bad idea?

mysql sql-tuning

What are the performance implications of Oracle IN Clause with no joins?

Merge join CARTESIAN

Please help me optimize this MySQL SELECT statement

mysql sql sql-tuning

Query statement consume quite long time on execution on oracle

need to tune this sql query to improve performance

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

Does "TABLE ACCESS BY INDEX ROWID" means optimizer using index or table?

Is MySQL naturally slow at this kind of query, or do I have it misconfigured?

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