Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in query-performance

How to avoid sort operator in a select query

SQL Server bad performance with a lot of ORs and repeating criteria using UPPER()

Query with different value executes differently

How to efficiently query MongoDB for documents when I know that 95% are not used

mongodb query-performance

Index Access for Calculating Hamming Distance

Finding table size (in MB/GB) in Spark SQL

Are indexes used if the WHERE clause contains unindexed columns

Oracle Db 11.2 NLS_SORT Index Range Scan Performance

Distinct Log Files For Error,System Queries,Query Debug For Postgresql

Postgres performance for a table with more than Billion rows

Should I create an index on these columns?

Oracle Selecting Index Optimisation

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

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