Re: How to estimate the memory usage in join table?
From: Steve Long <steven.long_at_erols.maps_on.com>
Date: Wed, 30 May 2001 18:09:32 -0400
Message-ID: <9f3r5o$71l$1_at_bob.news.rcn.net>
Date: Wed, 30 May 2001 18:09:32 -0400
Message-ID: <9f3r5o$71l$1_at_bob.news.rcn.net>
use tkprof and execute the query. it will tell you exactly how much is used.
"Pong Hay Chi" <alanpong_at_netvigator.com> wrote in message
news:9eoli8$pk11_at_imsp212.netvigator.com...
> 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?
>
> Thanks.
> Rgds.
> alan
>
Received on Thu May 31 2001 - 00:09:32 CEST