Skip to content
DbaFix
Just share answer and question for fixing database problem
MENU
  • HOME

Category: Query Performance

Simple select is taking too long

By adminPosted on February 9, 2023

Question : I am facing an issue with the performance. The selection of data from table is taking more than […]

Do MySQL sub-queries essentially use as much overhead as separate queries?

By adminPosted on February 8, 2023

Question : If I have a query like this: SELECT name FROM ( SELECT * FROM `table` WHERE id IN […]

Getting each status change in a table

By adminPosted on February 8, 2023

Question : I have a table that holds status changes per item. The item can go in and out of […]

Can spatial index help a “range – order by – limit” query

By adminPosted on February 7, 2023

Question : Asking this question, specifically for Postgres, as it has good supoort for R-tree/spatial indexes. We have the following […]

MySQL 5.7 performance issue with 300 GB Innodb [closed]

By adminPosted on February 7, 2023

Question : Closed. This question needs to be more focused. It is not currently accepting answers. Want to improve this […]

Why is PostgreSQL selecting a slow Seq scan when an index scan would be better?

By adminPosted on February 6, 2023

Question : I have the following tables in a Postgres 9.6 DB: create table baseDimensions( id serial not null primary […]

What could be the possible reasons for cardinality estimates being very inaccurate in an execution plan?

By adminPosted on February 6, 2023

Question : I have a query that is selecting some data out of a table. The execution plan shows that […]

Improve Insert performance for 200 Million rows

By adminPosted on February 6, 2023

Question : How can the following insert statement be improved – which varies from 20mins on certain days to 70-140mins […]

Why is LIMIT killing performance of this Postgres query?

By adminPosted on February 5, 2023

Question : I have a Postgres materialized view: Column | Type | Modifiers ———————+——————-+———– document_id | character varying | recorded_date […]

Find missing timestamps grouped by key: finding gaps in my data

By adminPosted on February 4, 2023

Question : I have a table that has a timestamp, some data and a identifying key for the data source: […]

  • 1
  • 2
  • 3
  • …
  • 136

Recent Posts

  • Backups fail to copy over the network
  • You do not have permission [closed]
  • What are your use-cases for HandlerSocket?
  • Sqlite query slow whilst it should be fast
  • Should I normalize a relational database design if I know the data will never be updated?
  • Index not picked up on nullable boolean column
  • Can we protect data form Database Administrator by encrypting the data?
  • Oracle 12c SYSTEM user locked out
  • Max from 2 columns with priority date col then the seq col Oracle
  • MySQL incremental backups per database (not global)
  • Does PostgreSQL/PostGIS use R-Tree or R*-Tree?
  • Implementing a simple ERD in MySQL: is the implementation below 100% compliant with the ERD?
  • Postgres Vacuum in Function
  • How can we improve this PIVOT operation? ( SQL Server 2008 R2 )
  • mongodb restore multiple collections with single command
  • GRANT privileges to table elements
  • Is there any way to perform atomic updates of stored procedures in MySQL?
  • How to Transfer SSMS “Font & Color” settings from one machine to another?
  • SQL Server 2012 Intellisense Support for Extended Events
  • Multi-tenant database

Categories

  • Database Backup
  • Database Design
  • Database Index
  • Database Optimization
  • InnoDB
  • Join
  • MariaDB
  • MongoDB
  • MySQL
  • Oracle
  • Performance
  • Permissions
  • Postgresql
  • Query Performance
  • Replication
  • Security
  • SQL Server
Proudly powered by WordPress / Support by: DizzyCoding