Re: Index query - monotonically increasing columns

"Norman Dunbar" <Oracle_at_MSSQLBountifulSolutions.co.uk> wrote in message news:baf81u$47k$1$8300dec7_at_news.demon.co.uk... Morn Norm (I like the sound of that sorry)

> I'm working on a little something at the moment in my spare time and I
have
> a table which will get bigger and bigger on a daily basis. Not too much
> expansion, but rows will be added daily - say about 50 - 100 rows per day.

<snip>

> I'm going to test this out at work at lunchtime - if I can - and see what
it
> does to the index, but I was wondering if this is a halfway decent
> solution. As far as I can see, the data will be spread out nicely, as the
> letters are randomly generated, I'll be re-using index entries after rows
> have been archived and I shouldn't be troubled by ever increasing index
> depths as I would using the sequence alone.
>
> What do you think? Is it a good idea or am I barking again ?

On the basis of 36500 records a year I wouldn't bother. 36500 records a week might make it an interesting experiment.

-- 
Niall Litchfield
Oracle DBA
Audit Commission UK