Question : I have a question on indexing strategy as i am trying to do indexing for a database. I […]
Tag: covering-index
Key lookup still happening after creating covering index
Question : I’ve implemented a covering index to avoid a key lookup: CREATE INDEX IX_StatusHistory_Covering ON StatusHistory(ID) INCLUDE (Status_ID, StatusComment, […]
Advantage of using INCLUDE as against adding the column in INDEX for covering index
Question : Postgres docs state the following about Index-Only Scans and Covering-Indexes: if you commonly run queries like SELECT y […]
Indexing Strategy for the query performance
Question : I have a question on indexing strategy as i am trying to do indexing for a database. I […]
Postgres 11+: are covering indices (INCLUDE) useful for join/where conditions?
Question : I’d like to better understand when covering indices can be useful to make index-only scans possible in Postgres […]
Covering index used despite missing column
Question : I have the following query, using MariaDB 10 / InnoDB: SELECT id, sender_id, receiver_id, thread_id, date_created, content FROM […]
Why a query is not covered when using a range operator on documents?
Question : I have created the following 1000 documents: for(i=0;i<1000;i++){db.doc.insert({“doc”:{“k1″:”v_”+i,”k2″:i},”scal”:i})} So a document looks like this: var d1 = db.doc.findOne() […]
Postgres 11+: are covering indices (INCLUDE) useful for join/where conditions?
Question : I’d like to better understand when covering indices can be useful to make index-only scans possible in Postgres […]
Can a non-clustered index be transformed to a covering index in SQL Server?
Question : I have a non-clustered index which includes one column. Now I want to alter the index and add […]