wood burning stoves 2.0*
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 EJB 3 in Action this week in the EJB and other Java EE Technologies 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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Count(*) is good but very expensive
 
Similar Threads
Needed! Java Developer! Immediate need! Ugent!
primitive as attribute
Interpreter
Record Count
Moving from Oracle to DB2