Re: Performance / Index

From: Nuno Souto <nsouto_at_nsw.bigpond.net.au.nospam>
Date: 2000/04/12
Message-ID: <38f44d28.3600480@news-server>#1/1

On Tue, 11 Apr 2000 17:32:45 +0100, Duarte Nuno Sousa <Duarte.Sousa_at_solsuni.pt> wrote:

>I'm having some performance problems with my index's.
>I have bitmap indexes and when i rebuild them, all the same queries that
>before the rebuild takes about 1/2 minutes to run now it's running in
>7/8 minutes.
>My Database have 120Gb and it's running in a Sun E3500 with 4
>UltrasparcII and have 2Gb of memory
>All the tips and Hits are Welcome.
>
>

Have you re-analyzed the tables AND the indexes? Run an EPLAIN PLAN on the queries to check if it is full scanning or doing hash/merge joins where it shouldn't. Also, was the performance measured against previous bitmap indexes or where they B-trees? Bitmap indexes are better in very specific cases. Not all of them.

Cheers
Nuno Souto
nsouto_at_nsw.bigpond.net.au.nospam
http://www.users.bigpond.net.au/the_Den/index.html Received on Wed Apr 12 2000 - 00:00:00 CDT