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
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
 
 
subject: Count(*) is good but very expensive
 
Similar Threads
primitive as attribute
Record Count
Interpreter
Needed! Java Developer! Immediate need! Ugent!
Moving from Oracle to DB2