Re: How can I get estimated rows count?
- From: "joeNOSPAM@xxxxxxx" <joe.weinstein@xxxxxxxxx>
- Date: Sat, 11 Aug 2007 21:58:03 -0000
On Aug 11, 8:42 am, "qbin" <qbi...@xxxxx> wrote:
Hi,
Is there a possibility to get estimated rows count for asynchronous
cursors through JDBC?
--
Greetings, Tomek.
Nothing cheap or accurate, but the only estimate is to do a "select
count(*) ..." before
the real query if you need to. The best approach is to adhere to the
notion that you
use fancy SQL and procedures to do most of your data manipulation in
the DBMS, and
only extract data that you need to display right now. Good luck,
Joe Weinstein at BEA Systems
.
- References:
- Prev by Date: [MS SQL 2005] How can I get estimated rows count?
- Next by Date: Hibernate entity states + loading
- Previous by thread: [MS SQL 2005] How can I get estimated rows count?
- Next by thread: Hibernate entity states + loading
- Index(es):
