Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in query-performance

How effective is creating index on column having two types of values only

Create index on EXISTS condition

MySql query tooks 0.16 seconds in PhpMyAdmin, but 10 minutes in Php

Getting terrible performance on newly created views

PostgreSQL citext index vs lower expression index performance

MS SQL: What is more efficient? Using a junction table or storing everything in a varchar?

value limitation in an IN clause Oracle

Is there an alternative to SET STATISTICS TIME which also shows the statements?

What is the fastest way to select a single row in SQL? (SQL Server)

Why is this CTE so much slower than using temp tables?

Cassandra performance on clustered column sorting vs secondary index

Same unit of operation takes different length of time in two pretty similar queries

SQL Joins vs Subquery - performance difference

What is the most performant way to query Process Performance Counters?

Reuse mysql Subquery in InnerJoin

Understanding rows_examined_per_scan and rows_produced_per_join

Postgres `gin_trgm_ops` index not being used

Oracle "Total" plan cost is really less than some of it's elements