Skip to Content
0
Former Member
Aug 07, 2016 at 08:54 AM

Cube performance improvement

24 Views

Hello everyone,

I have cube (40 mlns. rows), quries based on it are very slow,

cube contains diffrent ID's, and also text values for it (as masterdata included in cube).

I mean for ex. Plant ids and names both included into cube.

I am planing to create new cube using old template but to exclude text values.

I have to questions - will performance improve if:

1. I will exclude text values. It is not being used in queries. I am using masterdata.

Do text values decrease performance if it is not included in query?

2. If I have values for certain field with 15 char. maximum and this field is 30 chars maximum (type CHAR), in other words field is unnecessary long - does it hit performance?

Thank you.