Forum Discussion
Solved
incremental refresh do not provide much performance improvement
I have a table with over 100 million rows of data,so I use incremental refresh,only refreshed the last two months data,it's about 10 million lines.
In initial refresh,it took me 03:43:38.086,the next time I do an incremental refresh,it took me 02:40:26.389 ,only an hour short.
Why does incremental refresh take so little time to improve?
Looking forward to your reply.
If the query doesn't fold there isn't much of a performance improvement. But at least you get partition control.
