My table has 650M rows (according to a fast but decently precise estimate from a query I found here). It has a text column called receiver_account_id, and I need to be able to search those records like: r.receiver_account_id LIKE '%otherWordsHere'.…
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.…
I have a table, it has these columns: id | tx_hash | tx_status | created_at ----------+---------+-----------+--------------------------- 15000000 | 0x0011 | 0 | 2021-07-30 06:42:00.267694 15000001 | 0x0011 | 0 | 2021-07-30 06:42:00.267694 15000002 | 0x0011 | 0 | 2021-07-30 06:42:00.267694…
I have a table which has a large amount of variable data with the key field in particular that has, at the time of writing 14 variants. The structure is as below: CREATE TABLE `device_data` ( `id` bigint(20) unsigned NOT…
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 have two separate columns in Postgres Database for Date and time I had Index in Date column and time column. As earlier I need to filter the data using date filter only Index worked perfectly. But In recent requirement…
Suppose the following data: user_id timestamp value -------------------------- 2983 2022-01-01 12:01 100 2983 2022-01-01 12:04 106 2983 2022-01-01 12:06 101 2983 2022-01-01 12:10 110 2983 2022-01-01 12:11 112 2983 2022-01-01 12:13 115 2983 2022-01-01 12:15 102 I'm trying to perform…
select * from table where '2022-09-30 13:05:30.000' between concat(start_date, ' 00:00:00.000') and concat(end_date, ' 23:59:59.999') The above example does not use index because it uses the concat function What should I do? start_date, end_date type 'yyyy-MM-dd'
Within my db I have table prediction_fsd with about 5 million entries. The site table contains approx 3 million entries. I need to execute queries that look like SELECT prediction_fsd.id AS prediction_fsd_id, prediction_fsd.site_id AS prediction_fsd_site_id, prediction_fsd.html_hash AS prediction_fsd_html_hash, prediction_fsd.prediction AS…
There is a table with these columns: Name Type Id int DateTime datetime(6) CompanyId int (FK) IsExcluded tinyint(1) There are 2 BTREE indexes: CompanyId ComapnyId,DateTime,IsExcluded Following select is using the first index with only one column and this select takes…