I'm working on a project with a MySQL database. I have some CTEs that summarize features of the users (each CTE summarizes one feature). Then I have a last query that joins all other CTEs on a column named user_id.…
I have to make a trivia webpage where you have a question with answers displayed on screen, with 10 questions to cycle through. I have an array from a json file which contained the info. I bring in the info,…
How do I define my indexing policy if I only want to index (the default) "id" in Azure Cosmos Containers? If I do the below, would id be dropped as an index? or would it not index anything except for…
I have three tables: A(id varchar(36) pk, c_id varchar(36)) with 1.2M rows B(id varchar(36) pk, c_id varchar(36)) with 0.6M rows C(id varchar(36) pk, "number" varchar(128), "status" varchar(255)) with 5.4M rows id is UUID string, "number" is 12 symbols long string,…
Should I put INDEX on staff_id & client_id CREATE TABLE conversation ( id INT(7) UNSIGNED AUTO_INCREMENT PRIMARY KEY, staff_id INT(7) UNSIGNED, client_id INT(7) UNSIGNED, summary TEXT, FOREIGN KEY (staff_id) REFERENCES staff(staff_id) ON DELETE CASCADE, FOREIGN KEY (client_id) REFERENCES client(client_id) ON…
Edit: EXPLAIN result for the first two queries when using src_cus_lang: EXPLAIN result for the last two queries when using cust_lang_src: Original post: I'm using MySQL and have a table as follows: CREATE TABLE tm( id INT AUTO_INCREMENT PRIMARY KEY,…
I have a json dataset where each item/index can contain 2 nested dictionaries. The problem is that one of these nested dictionaries contains all of the exact key:value pairs as its parent dictionary. To put it in other words, I…
I'm working with a few large row count tables with a commonly named column (table_id). I now intend to add an index to this column in each table. One or two of these tables use up 10x more space than…
Case Inputs Mysql Version on both Prod and test: 5.7 Query: SELECT t1.id t1.accountId, t2.col1 FROM table1 t1 INNER JOIN table2 t2 ON (t2.Id = t1.id) WHERE 1 AND MOD(t1.id, 20) = 0 AND t1.col1 = 0 AND t1.col2 <=…
Consider we have A,B,C,D,E,F,G,H columns in my table and if I make composite indexing on column ABCDE because these column are coming in where clause and then I want composite indexing on ABCEF then I create new composite indexing on…