I have a table such as follows: CREATE TABLE Associations ( obj_id int unsigned NOT NULL, attr_id int unsigned NOT NULL, assignment Double NOT NULL PRIMARY KEY (`obj_id`, `attr_id`), ); Now the insertion order for the rows is/will be random.…
Here is the table data id time amount 1 20221104 15 2 20221104 10 3 20221105 7 4 20221105 19 5 20221106 10 The id and time field is asc, but time can be same. The rows are very large,…
I'm trying to make a very simple query to a MySQL 5.7 database but the query is slow and the explain shows it is not using the index, although it lists it as a possible key. Below is the query,…
I am currently working on a project that has 2 very large sql tables Users and UserDocuments having around million and 2-3 millions records respectively. I have a query that will return the count of all the documents that each…
Tell me how to optimize the deletion of data from a Postgre table I have a table like this: CREATE TABLE IF NOT EXISTS test ( group varchar(255), id varchar(255), type varchar(255), ); INSERT INTO test (group, id, type) VALUES…
The below query is taking time to execute. does this have any rewrite possibilities? Query; SELECT t_product.a_productid, t_product.a_mpactive, t_product.a_active, trim( substring_index(a_reference, '_',-1)) as a_reference, t_product.a_shopid, t_productlang.a_name, t_deactivatedproduct.a_reason FROM t_deactivatedproduct inner join ( SELECT max(a_deactivatedproductid) as a_deactivatedproductid FROM t_deactivatedproduct GROUP by…
I know that this MariaDB version 5.5.68 is really out of date, but I have to stay with this old version for a while. Is there a way to prevent toxic selects, possibly blocking MyISAM tables for a longer time…
This query has so many joins and i have to apply conditions on joined table columns to get the desired results but query becomes slow when i apply condition on a datetime column. Here is the query select distinct v0_.id…
I'm not clear how to search for this, if there's a duplicate feel free to point me to it. I'm wondering if there's a way to tell mysql that something will be sorted before filtering so that it can perform…
I am using tableau for a dashboard that pulls data in from a MySQL database. It works perfectly but the query takes too long to execute. The data is limited to the previous 2 years and the most recent Saturday…