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

Tag: ugly-or

PostgreSQL slow performance using “or” operator

By adminPosted on August 20, 2022

Question : Development team on my company built the following query: select distinct c.customer_id from table1 c join table2 l […]

Why is an OR statement slower than UNION?

By adminPosted on January 17, 2021

Question : Database version: PostgreSQL 12.6 I have a table with 600,000 records. The table has the columns: name (varchar) […]

Recent Posts

  • Enumerate drives available to SQL Server
  • MySQL Select Query not using Required Index
  • Error Code: 1845. ALGORITHM=INSTANT is not supported for this operation. Try ALGORITHM=COPY/INPLACE
  • MY Sql group by taking too much time [closed]
  • Does joining to the same table twice have a predictable performance impact
  • Using COLLATE with UNION
  • Why Does the Transaction Log Keep Growing or Run Out of Space?
  • SQL Server 2014 All Administrator Accounts Disabled
  • Does Postgresql apply the same type of locks on UPDATE with range condition and on UPDATE with in-set condition?
  • Mysql join heavy query on large tables taking hours
  • Is it possible to use Change Tracking on a Replication target?
  • Calculate percent changes in contiguous ranges in PostgreSql
  • Does having no brackets at “WHERE” produce same results as having brackets? [closed]
  • mysql slave restore database ERROR 3079
  • MySQL 8 roles – I’m probably missing something obvious
  • Migrating Oracle 9i database to MySql database on a different Windows Server
  • How to skip already created table while importing dump file in MySql
  • Hash aggregate bailout
  • multi-column FKs with NULL values [duplicate]
  • Running a task without waiting for the results in Postgres 11 on RDS

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