Re: EXEC_SQL Question
From: OraSaurus <granaman_at_not_home.com>
Date: Fri, 22 Oct 1999 23:43:30 GMT
Message-ID: <CE6Q3.777$1L2.34801_at_news.rdc1.ne.home.com>
Date: Fri, 22 Oct 1999 23:43:30 GMT
Message-ID: <CE6Q3.777$1L2.34801_at_news.rdc1.ne.home.com>
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.