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.