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@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 Wed May 30 2001 - 17:09:32 CDT

This message: [ Message body ]
Next message: Michael Bonfert: "DB Design Patterns"
Previous message: Steve Long: "Re: Uniqueness, NULLs and design options"
In reply to: Pong Hay Chi: "How to estimate the memory usage in join table?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US