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

Tag: index-tuning

Simplify and optimize a complex query

By adminPosted on February 7, 2023

Question : Our site has a chronological event feed that uses MySQL. We have noticed that some of the queries […]

How to determine if an Index is uselss in Percona MySQL?

By adminPosted on February 7, 2023

Question : Using Percona Server 5.5 I’ve a table which stores user activty (lets call it user_activity). It was created […]

What strategy does MySQL optimizer use when choosing between two indexes?

By adminPosted on February 7, 2023

Question : In question: Optimize a query with two range conditions the OP wanted to know if there were a […]

Search for nested values in jsonb array with greater operator

By adminPosted on February 6, 2023

Question : Here is the table definition (simplified): CREATE TABLE documents ( document_id int4 NOT NULL GENERATED BY DEFAULT AS […]

Oracle not using index when > used in where clause

By adminPosted on February 5, 2023

Question : We have a relatively classic scenario where the date clause of the query generated by the application uses […]

Does the length of the index name have any performance impact?

By adminPosted on February 3, 2023

Question : This may seem silly, but in trying to stick to my standard nomenclature when naming indexes in our […]

Index Maintenance on busy OLTP database

By adminPosted on February 3, 2023

Question : I have a database where constant read writes happening all the time. Searches are being done with wild […]

PostgreSQL is not using index with large data

By adminPosted on February 1, 2023

Question : Enviroment My PostgreSQL (9.2) schema looks like this: CREATE TABLE first ( id_first bigint NOT NULL, first_date timestamp […]

MySQL using a index referencing a different column

By adminPosted on February 1, 2023

Question : I have a large table which uses a versioning system in the table. When a record is updated […]

How to optimize a query for < operator

By adminPosted on February 1, 2023

Question : I have a SELECT that is very slow when using < operator I’m looking for fixes or workarounds […]

  • 1
  • 2
  • 3
  • …
  • 77

Recent Posts

  • Write filename, servername/IP and date+time in spool file
  • Designing a table with multiple null FKs
  • I am trying to get the string between hyphen (-) which is before (+) upto next colon (:)
  • Why would a SELECT INTO cause an arithmetic overflow?
  • Possibility to implement time to execute / TempDB usage restrictions on some role groups in SQL Server?
  • Login failed for user – Error 18456 – Severity 14, State 38
  • comparing two values in same column with another column using AND condition
  • Slow running aggregate of aggregate query
  • Is it possible to get seek based parallel plan for distinct/group by?
  • PostgreSQL replication: out-of-sequence timeline ID, when former master made slave
  • Autogrowth Analysis in PROD DB based on the trace file data
  • Single versus Multiple databases
  • Does a user who has permissions to select from a view also need select granted to the children entities of that view?
  • Parse a string to find data between delimiters, multiple occurrences
  • Oracle multiple databases on same server [closed]
  • Help to create indexes to improve query performance and reduce report generation time
  • Error while granting select privilege
  • Native checksum table says there’s a difference, pt-table-checksum does not
  • Row count from a certain table in multiple databases
  • postgres table sizing inconsistency

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