Skip to Content
0
Jan 21, 2012 at 05:58 PM

how to find data compression and speed

40 Views

1. whats the command/way for viewing how much space the data has taken on its HANA tables as oposed to the same data in disk . I mean how do people measure that there has been a 10:1 data compression.

2. The time taken for execution, as per seen from executing a same SQL on HANA varies ( i see that when i am F8 ing the same query repeatedly) , so its not given in terms of pure cpu cycles , which would have been more absolute .

I always thought that there must a better way of checking the speed of execution like checking the log which gives all data regarding executions , than just seeing the output window query executions.