Question : Lets take an array of ids of size n in the application level. for instance [132,3425,13,13,… 392] where […]
Category: Performance
How to avoid a subquery in FILTER clause?
Question : Schema: CREATE TABLE “applications” ( “id” SERIAL NOT NULL PRIMARY KEY, “country” VARCHAR(2) NOT NULL, “created” TIMESTAMP WITH […]
Is it better to separate a big query into multiple smaller queries?
Question : There are situations which require having really big query joining several tables together with sub select statements in […]
Creating an Index that is not used by a (SELECT) query reduces performance of that query
Question : I have just watched this video by Pinal Dave. He has a SELECT query that produces ~370k reads […]
How Does Table Partitioning Help?
Question : I am having difficulty to grab the idea of pros and cons of table partitioning. I am about […]
Faster query when joining data from multiple tables
Question : I’m looking for a way to make a database query faster. The table parts has over 6 million […]
Storing reports with a lot of rows in relational database (Oracle)
Question : I am setting up a relational database (Oracle) to store some reports with the following specifications: Each report […]
What are the downsides of running DBCC FREESYSTEMCACHE (‘TokenAndPermUserStore’) hourly?
Question : I have been seeing some concerning behavior in the SQL Server memory caches on one of our production […]
Can oscillating number of fragment decrease FTS query performance?
Question : I’ve got a FTS Catalog on a table containing ~106 row. It used to work like a charm, […]
Slow query / Indexes creation (PostgreSQL 9.2)
Question : I have the following Query: explain analyze SELECT split_part(full_path, ‘/’, 4)::INT AS account_id, split_part(full_path, ‘/’, 6)::INT AS note_id, […]