UnSubscribe
Thanks for the information . Seems when running select query [with variations
] for terabyte of data , somehow system memory consumption jumps to 8GB ..
Is it possible to suggest some equation like this ; For eg
select a,b,c from table ;
Row_memory_usage = Total_rows_in_the_table * row page
Can we get an idea of the amount of memory being consumed by category, for
instance, the amount used to store the results of the sub-query, the amount
consumed by intermediate joint results, the amount used by the sort, the amount
used by the grouping and aggregation. The more detail the bette