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 ...
databaseanswers.net Latest Questions
In Python: I got a MongoDB collection defined as Person whose fields are name (string) and hobbies (dictionary). I also defined some indexes on the "name" and "hobbies.sports" fields: class Person(gj.Document): name = StringField(required=True) hobbies ...
I’m wondering (I know it’s stupid, but…) why the first query works in postgreSQL 11 by index scan (using a GIN index), and the second and the third do not. select * FROM test_tbl WHERE "TEST_COL" like '%stinge'::text select * ...
I am working with Azure Managed Instances for hosting a data warehouse. For the large table loads the indexes are removed and rebuilt instead of inserting with the indexes in place. The indexes are re-created using a stored ...
I’m creating a table with four columns, inside a MariaDB database, and I want allow unique combinations of three of them–id_a, id_b, id_c: CREATE TABLE `example` ( `id_a` int(10) UNSIGNED NOT NULL, `id_b` int(10) UNSIGNED NOT NULL, `id_c` ...
I have a total of over 6,000,000 rows of data in this table, after filtering it by where condition, there are about 120,000 rows of data. Currently I have created two multi-column indexers CREATE INDEX "IDX_module_method_height" ON "events" ("module", "method", "block_height") CREATE INDEX ...
I am trying to optimize a few stored procedures in a MySQL database. A few columns have more than one index. These columns are used in joins and WHERE clauses. Which do I keep and which do I remove to improve ...
I am setting up an index maintenance job for my busiest server & I just wanted to know in a brief detail, what @WaitAtLowPriorityMaxDuration is used for in Ola Hallengren script. I browsed the web but couldn’t get a brief ...
I have a system with a large number of tables that contain historical data. Each table has a ts_from and ts_to column which are of type timestamptz. These represent the time period in which the data for a particular row ...
Suppose the following data: user_id timestamp value -------------------------- 2983 2022-01-01 12:01 100 2983 ...