Question : What is the ideal Composite Index in MySQL for the following query on an InnoDB Table1? SELECT ColA […]
Tag: index-tuning
What is the best index strategy or query SELECT when performing a search/lookup BETWEEN IP address (IPv4 and IPv6) ranges?
Question : Question: Is there a better indexing strategy or query SELECT that I can use for looking up one […]
What index can I create to help a query using multiple datetime columns and datetime functions in its where clause?
Question : SQL Server 2016 I have the following query: SELECT [Id], [Descriptor] FROM [Networks] WHERE ( [ValidFrom] <= SYSDATETIMEOFFSET() […]
No index used warning in WHERE column IS NULL
Question : I’m getting this warning: No index used in query/prepared statement SELECT * FROM mTable WHERE my_column IS NULL […]
How to create some GIN index concurrently in Postgresql
Question : I have a large table: CREATE TABLE hh(h int8[] not null, file int8 not null), and GIN-index over […]
Multicolumn index and performance
Question : I have a table with a multicolumn index, and I have doubts about the proper sorting of the […]
How can I improve the speed of a query on a 20 million+ row table?
Question : I have a query that is used for getting internet traffic statistics of certain IP addresses. There are […]
MongoDb use indexes partially
Question : Can mongodb take advantage of an index partially? I’m not talking about using a “partial index” ( https://docs.mongodb.com/manual/core/index-partial/ […]
How to index WHERE (start_date >= ‘2013-12-15’)
Question : I have a table named items, and inside the table there is a some_date column, with date as […]
mysql innodb index: better one big or many compact?
Question : I’ve a question for an expert in how innodb indexes are structured (mysql 8.0.18) Say I have 4 […]