File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and Relational Databases 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 RabbitMQ in Depth this week in the Open Source forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Count(*) is good but very expensive