Re: How to estimate the memory usage in join table?
From: Jan Hidders <hidders_at_REMOVE.THIS.win.tue.nl>
Date: 27 May 2001 14:36:14 GMT
Message-ID: <9er3cu$67m$1_at_news.tue.nl>
Date: 27 May 2001 14:36:14 GMT
Message-ID: <9er3cu$67m$1_at_news.tue.nl>
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 HiddersReceived on Sun May 27 2001 - 16:36:14 CEST