Re: How to estimate the memory usage in join table?

Pong Hay Chi wrote:
> In a typical inner join tables like :
> select somefields,... from table1 inner join table2
> where .... order by ....
>
> How to estimate the memory usage in order to do so?
> Any formula?

If you want to make a meaningful estimate you have to know more about how the join is computed. Depending on that the estimate may range from the total size of the result to only two disk pages.

-- 
  Jan Hidders