Query Size Estimation without Runing it

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. Received on Thu Feb 17 2000 - 00:00:00 CET