on 03-05-2019 7:24 PM
at my current work , we are going to create couple tables that's couple of thousand columns wide . I suppose there is not much read penalty , but there is probably some penalty during writing / delta merging .
can any one share some light on whats the optimum max number of columns in a columnar table ( like 500 columns is ok )
Hello,
I think the performance is based on the how it is designed and rather than no. of columns.
For example Timestamp is the most expensive statement.
From HANA Studio you may use M_EXPENSIVE_STATEMENTS view for the details, please enable the trace under performance in the HANA Studio.
Thanks.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.