Forum Discussion

IanR's avatar
IanR
Icon for Helper III rankHelper III
8 years ago

Query Folding in Dynamics 365 CRM

Hi, Is query folding possible with an ODate connection to Dynamics 365 (CRM Online)? All my queries have the View Native Query right-click option disabled, which leads me to believe that query foldi...
Need Help
IanR's avatar
IanR
Icon for Helper III rankHelper III
8 years ago

Can I just confirm something?

At moment my first steps for each table that I import are to remove the columns that I don't need and filter out the rows that I don't need. I am doing this promarily to try and speed the refresh up. Is this pointless? In the absence of query folding does does everything have to be downloaded, all columns and all rows, before antything can be removed? Which means that I can be squeaky clean with best practice but it won't make any difference to the refreesh time?

 

 

Anonymous's avatar
Anonymous
Not applicable
8 years ago

IanR

It will reduce the refresh time after you remove unwanted columns and rows. And yes, you need to import all columns and rows , then remove the columns and rows you don't need.


Regards,
Lydia