aspose file tools*
The moose likes JDBC and the fly likes Count(*) is good but very expensive Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Count(*) is good but very expensive" Watch "Count(*) is good but very expensive" New topic
Author

Count(*) is good but very expensive

Tal, Rosenberg
Greenhorn

Joined: Aug 02, 2001
Posts: 2
I'm strugling withe same issue. We are usiing Oracle as the DB server and the type of queries we use will not allow us to submit the query twice.
Does anyone know how Oracle stores the result count for the queries? (I know it does)
Thanks
 
wood burning stoves
 
subject: Count(*) is good but very expensive