Re: Some Questions

From: James Belton <jbelton_at_freenetname.co.uk>
Date: Wed, 23 Feb 2000 17:07:24 -0000
Message-ID: <8914of$f13$1@gxsn.com>

The analyze table /analyze index commands update the datadictionary with a variety of stats which help out the query optimiser.

If your optimiser is set to CHOOSE, then you should run an 'analyze.....' script regulary otherwise your performance will suffer.

The difference between compute and estimate is as it suggests. Estimate will cause the database to guess the stats. This is quicker than compute but not as accurate!

If you have a sequence, and you want to get the value (i.e the current number) out of it, you use:

select sequence_name.currval
from dual;

you can also you sequence_name.nextval which will also increment the sequence.

Hope this helps you out!

Regards

James Received on Wed Feb 23 2000 - 11:07:24 CST