on 08-17-2017 5:22 PM
hi!
We have a strange effect on customer's BW 7.50 on HANA.
Involved is a table which has storage type 'column store':
SAP told us many times that a table with storage type column store has an index on every column aka table field and we would not need to create secondary indices in SE11.
<update August 21 2017>
Funny fact, the system will create implicit single column index only for primary key fields and for attribute fields in certain situations.
</update August 21 2017>
On the customer system I ran ATC checks and had the checkboxes...
...active, since there is legacy code and there may be good old row-store-tables as well where I want to see bad access practice with lazy or no index care.
While watching the check results I wonder why my column store table shows up in the section "Large table ...: No first field of a table index in WHERE condition"
Remember: column store means that a key column is an implicit index.
Why do I see that select statement which does a WHERE-clause on a key field of the table in my ATC results?
Which section of documentation did I miss? Or do we have a bug in ATC? We appreciate your comment.
thx!
br chris
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.