query-optimization Examples and Free Source Code

SQLServer: Why avoid Table-Valued User Defined Functions?...

sql-server query-optimization user-defined-functions

How do I speed up querying my >600Mio rows?...

python sql sqlite query-optimization

Neo4j WHERE Predicates Based on Arrays vs. EXISTS and Relationships...

neo4j cypher query-optimization

Avoid using a cursor when creating new records in a table and update another with the newly generate...

sql sql-server query-optimization database-cursor

fastest way for getting concurrent entries in large database...

sql mysql query-optimization

Why is Postgres not using my index on a simple ORDER BY LIMIT 1?...

postgresql indexing query-optimization sql-order-by

Postgre join query not using expected index...

database postgresql indexing query-optimization

How many rows of data are deemed untenable and require a switch to a JSON column...

sql json postgresql query-optimization

Oracle not using index for `ORDER BY` clause, poor execution plan when combined with `FETCH FIRST n ...

sql oracle-database indexing query-optimization

Performance of JOIN on columns which have different type in each table...

sql postgresql database-design query-optimization

MySQL8 ORDER BY with JOIN uses filesort even though the result set is sorted already (based on index...

sql mysql query-optimization

Hibernate @OneToOne executes multiple queries even with @Fetch(FetchMode.JOIN)...

hibernate query-optimization fetch one-to-one

How can I simplify/improve the performance of this MySQL query?...

php mysql query-optimization

Where should we do the filtering - at the data layer or the service layer to optimize testability an...

design-patterns query-optimization service-layer data-layers testability

Fastest way to find which hours have 0 rows in a table with a month's data?...

sql-server t-sql query-optimization

SQL Inner join with where clause works fast with one condition, but not when activeFlag is added...

sql mysql indexing query-optimization

Why does TRY_CAST() / TRY_CONVERT() take so overly long for a view outer joined on itself but each s...

t-sql query-optimization

Slow MySQL query with multiple sub-queries in where clause...

sql mysql query-optimization unpivot

How to extract nested JSONB values in PostgreSQL with dynamic SQL query for a particular key?...

sql postgresql query-optimization jsonb

Do duplicates in the IN statement have an impact on performance?...

mysql query-optimization

SQL Scan vs Seek when using OR in where criteria...

sql-server t-sql query-optimization

Most efficient way to SELECT on a cluster table?...

performance select query-optimization abap sap-data-dictionary

Mariadb / mysql EXPLAIN to optimize data query...

mysql mariadb query-optimization

Improve processing time of applying a function over a vector and grouping by columns...

r performance data.table query-optimization lapply

Optimizing SQL join query with date comparison...

sql sql-server query-optimization

How do I speed up this strftime('%Y-%m', time_UTC) query?...

sql sqlite date indexing query-optimization

Why is PostgreSQL sorting a seemingly already sorted result set?...

database postgresql query-optimization relational-database database-indexes

Postgres with row level security does not optimize queries / uses one-time filters...

postgresql query-optimization row-level-security

Dynamic SQL vs. generic query with dynamic filters...

sql postgresql performance query-optimization dynamic-sql

Optimizing Oracle query join on a range of values (join on n between x and y)...

sql oracle-database query-optimization