Question : I have this query and I want to increase its performance by adding appropriate Indexes. DELETE FROM MYTAB1 […]
Tag: query
Multiple query to columns indexed in MySql
Question : I am trying to make a table with server-side page, so it can also apply filters for each […]
Oracle SQL for left outer join to rownum = 1 of another query?
Question : Background I have a query joining many tables together, the chief of which is a workorder table. I […]
Mariadb query time extremely increased after upgrade from 10.2 to 10.4
Question : After upgrading from Mariadb 10.2 to 10.4 extremely increased query time. On 10.2 query time is 0.5s. On […]
SQL (Postgres): query array Column which must be a subset of an array
Question : I have a table “article” and for each entry there are some “tags” stored (array column) name | […]
Batch query a lot of MySQLdump files
Question : I have a website for an event. I set up a cron job to back up the database […]
Recursive query on a self-referential table where each node has one link to its child’s node
Question : Consider the following table and data (fiddle available here): CREATE TABLE test ( id INTEGER NOT NULL AUTO_INCREMENT […]
How can I make this nested query more efficient?
Question : I have 3 tables: Room, Conference, and Participant. Room has many Conferences, and Conference has many Participants. I […]
How to get query execution time and query result at the same time? [closed]
Question : Closed. This question is off-topic. It is not currently accepting answers. Want to improve this question? Update the […]
Trigger to copy deleted rows to another identical table with Cascade Delete On
Question : I have two tables. Sale and SaleProducts SaleProducts contains all the products that have a Sale. 1 sale, […]