File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Win a copy of
RabbitMQ in Depth
this week in the
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)
I agree. Here's the link:
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