In article <7uoves$b0n$1_at_nnrp1.deja.com>, Sue Han <sue_han_at_my-deja.com> wrote:
>Hi,
>
>I want to get an estimate on number of rows that will be returned by a
>Dynamic SELECT statement before the actual rows are fetched.
>
>Someone told me:
>Informix reports this estimate in it's sqlca data structure when a
>cursor against the query is opened, however, these estimates are
>frequently way off. They depend on statistics gathered that may be out
>of date.
>
>Estimate is exactly what I want. I will get statistics regularly.
>
>Can EXEC_SQL do this and how? What about I connect to Oracle or
>non-Oracle DB?
Try getting the row count from user_tables...
The value is updated on 'analyze table TNAME [esitmate|comopute] statistics'.
- OraSaurus
--
- Remove "not_" to reply...
--
NOTICE TO BULK EMAILERS: Pursuant to US Code, Title 47,
Chapter 5, Subchapter II, 227, any and all nonsolicited
commercial E-mail sent to this address is subject to a
download and archival fee in the amount of $500 US.
E-mailing denotes acceptance of these terms.
Received on Fri Oct 22 1999 - 18:43:30 CDT
