Tagged Questions
2
votes
2answers
1k views
Reindexing a large database
I have a very large database (millions of rows) which has been indexed.
I receive a diff of rows from another source that I need to update in my database.
The problem I am facing is that is it ...
1
vote
2answers
253 views
Indexing of Data Warehouse tables?
Maybe I have misunderstood something but I can recall reading an article which said that there is no reason to create non-clustered indexes on very large data warehousing tables? That is because ...
9
votes
4answers
559 views
Where should one put indexes in a time dimension table?
After reading the Questions and Answers from this website about indexes, a question came to my mind.
What if, one is using a time dimension table with the lower level of granularity being the day. ...
