Automatic vs. demand indexes

[fp at casabellagallery.com]

Nancy posted:

[...]
> 
> However, I had cause to try the exact same thing with a Demand index. 
> Built on the same two fields: state & city
> Built with the same two lengths: 2 & 8
> 
[...]

I always thought demand indexes were really meant to be
used for reports not browse.  Truth is that I have never
used them.

I do have a couple of questions for you:

Q. Don't demand indexes need to be rebuilt every time you
   invoke them?  If not rebuilt, don't they have only data
   as per last built?

Q. If they do need to be rebuilt, do they actually rebuilt
   faster than using 'drop' within your code?

It never occurred to me you could use demand indexes this way
mainly because of my stated understanding (them having to be
rebuilt).

Regards,


Jose Lerebours