Re: Index to speed up "select count(*) from" queries...

Hi,

if You have the Enterprice Edition of Oracle8 than You can create a bitmap index for Your querry if the key is not unique. If the key is unique the index will be greater than an normal B*-tree index. The Oracle documentation tell You that a COUNT(*) runs very quick if You have a bitmap index espacially a count of all rows of the table. I don't know if it will be also faster if You have a where clause in Your statement. Maybe there is anybody out how can tell us.

Best regards

Ralph Ganszky

• The above opinions are mine and do not represent any official
• standpoints of my employer or third-party organizations.

tim_mcconechy_at_my-dejanews.com wrote:

> My application needs to do some count(*) queries...
>
> Is there some kind of index I can use to speed this query..
>
> On a table with 100000 records it takes a couple seconds longer than I
> would like...
>
> --== Sent via Deja.com http://www.deja.com/ ==--
> ---Share what you know. Learn what you don't.---
Received on Mon May 17 1999 - 10:52:59 CDT