Question : is there a work around for when you want to put an OR inside a filtered index? create […]
Tag: filtered-index
Why new nonclustered index cause more IO reads on table?
Question : We are in process of creating new non-clustered index for specific views. One of the view looks like […]
Temp Table Filtered Index Creation is Blocked When Stored Procedure is Run Multiple Times Concurrently
Question : Are there any known blocking issues in SQL Server 2014 that are specific to creating one or more […]
Why is my filtered index being ignored?
Question : –Setup, actual queries after the space –create table fltrind (a integer,b integer) truncate table fltrind DROP INDEX fltrind.nf […]
Why filtered index on IS NULL value is not used?
Question : Assume we have a table definition like this: CREATE TABLE MyTab ( ID INT IDENTITY(1,1) CONSTRAINT PK_MyTab_ID PRIMARY […]
SQL Server 2008 – Question about index behaviour
Question : I have a general question about advanced issues regarding index behaviour. In short, roughly one year ago, we […]
How to create a conditional index in MySQL?
Question : How to create an index to filter a specific range or subset of the table in MySQL? AFAIK […]
Use “LEN” function in “WHERE” clause in “CREATE UNIQUE INDEX”
Question : I have this table: CREATE TABLE Table01 (column01 nvarchar(100)); And I want to create a unique index on […]
Filtered index is not used when variable in WHERE condition
Question : Why MS SQL Server refuse using supporting filtered index in this scenario? — demo data CREATE TABLE #Test […]
Search with more than 5 Million recods With Posgres
Question : Search to be implemented for currently developing a project which is being developed using Spring Boot and Postgres. […]