HI , We are experiencing very slow running retrieval of data when fetch data from data View. Our tables are partitioned and contain huge data.(Date time/Yearly) Not sure what exactly we can do to enhance the performance.
We'll need a lot more information. What does your partition function look like, especially as compared to any WHERE clause in your view? Ideally, you'll want to have a query that is only going to get data from a single partition. Please post DDL for the tables along with row counts.