A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Win a copy of
EJB 3 in Action
this week in the
EJB and other Java EE Technologies
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)
I agree. Here's the link:
subject: Count(*) is good but very expensive
Needed! Java Developer! Immediate need! Ugent!
primitive as attribute
Moving from Oracle to DB2
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2014