A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
JDBC and Relational Databases
Count(*) is good but very expensive
Joined: Aug 02, 2001
Aug 02, 2001 20:38:00
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)
It is sorta covered in the
JavaRanch Style Guide
subject: Count(*) is good but very expensive
Moving from Oracle to DB2
Needed! Java Developer! Immediate need! Ugent!
primitive as attribute
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015