A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
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)
Did you see how Paul
cut 87% off of his electric heat bill with 82 watts of micro heaters
subject: Count(*) is good but very expensive
primitive as attribute
Needed! Java Developer! Immediate need! Ugent!
Moving from Oracle to DB2
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2014