on 06-17-2016 8:00 AM
Hi David,
Make the number of requests to 1 or 0 depending upon the no. of requests you see in your cube now...and run again.
Hope it helps....
Regards,
JP
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi JP,
Number of request = 0 is not advised for any DB. For example, if you use it for Oracle DB data loads will be slow after LO since no stats are available on the table.
If author is using HANA then number of requests = 0 is fine.
For all other DBs I'd suggest talking to DBA before changing this setting.
Regards,
Gersh
Hi JP,
As I said, it depends on the DB you use. For Oracle it has negative effect because F table becomes empty and doesn't have statistics. Therefore no INSERTs are going to use indices. In such case it's advisable to load first a small number of records, refresh statistics and then run bigger loads.
Not sure about other DBs.
Regards,
Gersh
Number of requests=0
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
15 | |
4 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.