Business Intelligence for Microsoft Dynamics - Blog

Indexing data warehouse tables Too many or too few indexes hurt performance. Not active indexes may disturb SQL server in generating the optimal execution plan. Managing indexes can become art that only experienced professionals can make right. Not accidentally, models in BI4Dynamics data warehouse are know to the same engine that generates the indexes, so…

Read more