Re: Query Size Estimation without Runing it

SQL Analyzer is running the query behind the scenes. There is no way they can guess the rowcount without executing the query.

msharaf_at_main-scc.cairo.eun.eg wrote:

> Hi
>
> Working in my research, i need to estimate the size of query
> result (numder of tuples) without actually runing it, which is
> a typical problem in query optimization.
>
> I wonder how can i do it in a simple & somehow efficient way,
> The SQL Server Query Analyzer, do this in a very good way, i
> wonder how it is doing it ?!!, does it keep some statistical data
> somewhere in the database ?!! & i wonder if i can use it thru
> programming, sending it the query & it returns back the estimated
> number of tuples ?!!
>
> Thanks a lot in advance, Mohamed
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

--
Note: These are my own views and not that of Goldman Sachs

Ivan Santhumayor
Firmwide Database Administration
Goldman Sachs & Co