Refresh Time for Incremental SPICE refresh taking a lot of time

Hi Community, I need one help. I have a simple SQL query but when I upload it in Quicksight using SPICE memory it takes about 1hr 30min (incremental refresh : refresh period after one hour in one day). Could you please suggest how can I improve this?

Hi @ApoorvaV and welcome to the QuickSight community!

How large is the dataset that you’re dealing with in this scenario? Additionally, when you mention that your SQL query is simple, what does it include?