cancel
Showing results for 
Search instead for 
Did you mean: 

How many columns can a columnar table have before the performance degrades

rajarshi_muhuri
Active Participant
0 Kudos

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 )

Accepted Solutions (0)

Answers (1)

Answers (1)

msundararaja_perumal
Active Contributor
0 Kudos

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.

rajarshi_muhuri
Active Participant
0 Kudos

does not matter the design , for the same design is there any difference in performance between pulling 10 columns from a 500 column table vs 5000 column table