[MS SQL 2005] How can I get estimated rows count?

Thread view:

Enable EMail Alerts

Start New Thread

qbin - 11 Aug 2007 16:38 GMT

Hi,

Is there a possibility to get estimated rows count for asynchronous
cursors through JDBC?

Signature

Greetings, Tomek.

Reply to this Message

joeNOSPAM@BEA.com - 11 Aug 2007 22:58 GMT

> Hi,
>
[quoted text clipped - 3 lines]
> --
> 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

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...