Re: count() question
James, just to understand covering indexes, in your second SQL, the columns being selected are "organization" and "count(*)"
My understanding of covering index, which may be wrong, is that it includes an index on all the columns referenced in an SQL statement.
So the covering index would include:
- organization
- client id
- paid
Is this incorrect? (Also I am guessing that the "count(*)" would just pick up one of the fields from the index)
Subject
Written By
Posted
Re: count() question
March 30, 2005 03:54AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.