Re: Performance / Index

From: Martin Hepworth <maxsec_at_totalise.co.uk>
Date: 2000/04/12
Message-ID: <38F42A86.39E0BB9B@totalise.co.uk>#1/1

Duarte Nuno Sousa wrote:
>
> Hi
> 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.
>
> Duarte Nuno de Sousa
> duarte.sousa_at_solsuni.pt

HI
make sure the tables in question are analysed otherwise the default optimiser won't use any indexes against the tables.

martin Received on Wed Apr 12 2000 - 00:00:00 CDT