I'm using MySQL 8.0.35 and I've two tables in my database: users and clients. Users can be searched by username, firstname, lastname, email, phone, document or even id. The clients table is used to track which users are clients of…
I have Table T T(A , B , C , D) With this query: Select A from T Where B = C Does having an index on D make a difference in the performance of the given query? Does having…
How to Create a Case-Insensitive Unique Compound Index in MongoDB? Question Body: I'm trying to create a compound unique text index in MongoDB with the following fields: tenant_id: 1 seller_id: 1 seller_sku_code: text However, I'm encountering an error when trying…
This is the table schema: CREATE TABLE IF NOT EXISTS events_table ( id UUID NOT NULL, company_id INT8 NOT NULL, employee_id INT8 NOT NULL, category_type_id UUID, event_type VARCHAR(255) NOT NULL, data_payload bytea NOT NULL, occurred_at TIMESTAMP WITH TIME ZONE NOT…
I created an immutable function as below: CREATE OR REPLACE FUNCTION GetCurrentDate() RETURNS DATE AS $p$ BEGIN RETURN CURRENT_TIMESTAMP::DATE; END; $p$ LANGUAGE plpgsql IMMUTABLE SECURITY DEFINER; And I use this in a UNIQUE INDEX's WHERE clause like: CREATE UNIQUE INDEX…
I have the following query: select count(*) as aggregate from users where date(created_at) < '2024-04-01'; It returns 2337355 which is a correct number. But it takes over 1.5 secs to be executed. Any idea how can I make it more…
In the database, there is a field that stores JSON, and the content is roughly as follows: "content":{"systemToken":false,"timezone":"America/Los_Angeles","totalCount":false,"userIds":[]}" The requirement is to query data where totalCount is true. SELECT * from task where column_a like '%"totalCount%' This query returns results,…
[ { "B4": 14, "B5": 12 }, { "B4": 58, "B5": 54 }, { "B4": 26, "B5": 65 } ] I want to create index ID in my uploaded json file. The json file look like as in the image.…
I have millions of rows of data in MySQL DB. Can you suggest me any services or platforms that support JOINS and fast data retrieval. I have looked on elastic search and manticore search, but these don't support JOINS. So,…
Does anyone know how to create Azure AI Search indexes for email .msg files? I have been able to find sample indexes for JSON content but can't seem to find samples that index email content. I would like to be…