How to estimate the memory usage in join table?
From: Pong Hay Chi <alanpong_at_netvigator.com>
Date: 26 May 2001 16:27:52 GMT
Message-ID: <9eoli8$pk11_at_imsp212.netvigator.com>
Date: 26 May 2001 16:27:52 GMT
Message-ID: <9eoli8$pk11_at_imsp212.netvigator.com>
In a typical inner join tables like :
How to estimate the memory usage in order to do so?
Any formula?
select somefields,... from table1 inner join table2
where .... order by ....
Thanks.
Rgds.
alan
Received on Sat May 26 2001 - 18:27:52 CEST