Skip to Content

ATC checks in BW on HANA regarding column store tables


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..., 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.


br chris

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers