Tagged Questions
2
votes
1answer
90 views
Indexed view not being used - SQL Server [duplicate]
I've a query with multiple joins which takes long time to return data for one date. I've created an indexed view on the same. I set all the required options appropriately, while creating view and ...
2
votes
1answer
379 views
Creating Bitmap Indexes on a Materialized View
I've been reading this article, discussing the benefits, tradeoffs, and potential problems with Bitmapped Indexes. It is mentioned:
Also, remember that bitmap indexes are only suitable for static ...
3
votes
1answer
100 views
Do operations on indexed views happen in parallel?
When I'm inserting into a table that has a view with a clustered index, the estimated execution plan appears to do the table insert and the view's clustered index insert operations in parallel.
Is ...
1
vote
2answers
767 views
WITH using INDEX hint in Oracle
I have a fairly complicated query. I have written two different query to accomplish my goal.
First one is using WITH, other one is using global temporary tables.
First One:
WITH A
(
KNO
..
)
, ...
