Query run time
Here is the situation. We have about 9 queries on two ODS, 3 on one ODS and 6 on the second inserted in a single workbook for our pricing area. The queries quite complex calculations and the workbooks use excel formulas and V-LOOK-UPS. Usually it takes about 2 minutes to run this workbook in development., for a month. But when we have created a MP each on each of these ODS(s), copied the same queries on to the MP(s) and created a new workbook. Now the same workbook with the MP queries is taking for ever to run. Does anybody has any ideas? Please let me know.
Thanks to you all in advance.