on 05-02-2019 6:16 PM
Hi,
In S/4HANA few tables have indexes created by SAP which exists on HDB (Hana Database).In case of tables having enormous entries e.g. SWN_NOTIF but are columnar table, when we do a select statement on this table, I got an extended code inspector check message saying, none of the fields match the index fields which exist in Hana Database.
However, being a columnar table would mean the default way of selecting data works in the similar way as with indexing. So why does this warning? In my view this was the potential reason for making columnar tables - making read access quickly.
Any thoughts here? Do we need to use or create indexes in columnar tables as well? Does anyone has experience from productive environments as to how does these Selects behave?
Thanks!
Hi,
looks like for resource optimization there are still indexes and caches.....
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
90 | |
9 | |
6 | |
6 | |
4 | |
3 | |
3 | |
2 | |
2 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.