Question : I’m working tuning a scientific database whose associated simulation is very insert intensive (i.e., run for a long […]
Category: Database Index
Execution Plan is NOT using INDEX, It uses Table Scan
Question : I know when it comes to using an index or a table scan, SQL Server uses statistics to […]
Indexed view not being used – SQL Server [duplicate]
Question : This question already has an answer here: What factors go into an Indexed View’s Clustered Index being selected? […]
Best way to compare strings using pre-built ngrams?
Question : I’m struggling with an n-gram problem and have been hunting the Web for examples to help me out […]
Why my index don’t update?
Question : I have created this index ORACLE/VIDEO# create index titolo_index 2 on titolo(titolo) 3 indextype is ctxsys.context 4 ONLINE […]
Tuning a query to fetch all the records in a day with certain status
Question : We are currently using Oracle Database: Consider a table TRANSACTION with the fields TRAN_ID, STATUS, CREATED_TIME, …. The […]
Why isn’t it possible to cast to a timestamp in an index in PostgreSQL?
Question : I am working with a JSON document which I receive from an external source. In this document, there […]
Creating an Index that is not used by a (SELECT) query reduces performance of that query
Question : I have just watched this video by Pinal Dave. He has a SELECT query that produces ~370k reads […]
Does MySQL reindex on update
Question : I have a users table with various fields which are getting updated frequently. i.e table have: userid – […]
Wrong estimated number of rows
Question : I’m trying to identify an issue I sometime experience on a stored procedure. I have to say that […]