Tag Archives: database

Using Extended Fetch

Hello there!

Today let’s talk about a very important thing! Extended Fetch!

Do you know what is extended fetch?

Extended Fetch is an option that can be used in MicroStrategy that returns multiple rows at one time when querying your Data Warehouse.

Without Extended fetch(the Default option): MicroStrategy returns data one row at a time. With Extended Fetch: MicroStrategy returns multiple rows at one time. Extended Fetch may therefore facilitate faster retrieval of query results, especially when the number of result sets is large.

There is a list of the supported (MicroStrategy didn’t update the list, so maybe your database can support extended fetch) databases in this link below:

https://resource.microstrategy.com/support/Authoring/DisplayTN.aspx?tnkey=32213&formatted=1

To use Extended Fetch, you have to make sure to use 2.0 ODBC Calls instead of 3.x ODBC Calls ODBC Version.

To inspect which ODBC version you are using for your database connection, just go to:

MicroStrategy Developer -> Administration -> Configuration Managers -> Database Instances -> Choose your Database Instance and Edit it -> Go to Advanced tab and look for ODBC Version section:

pic4

pic3

Now just go to General tab:

pic7

Choose your Database Connection and click on the Modify button.

Go to Advanced tab and check: “Use Extended Fetch” option:

pic6

If you are using Tier-3 connection, restart your Intelligence Server to apply those settings. If using 2-tier, just disconnect and reconnect to your project source.

That’s it.

Hope it helps.

God bless you.