RE: full-scan vs index for "small" tables

> > There's just this inconvenience of
> > having to inform the Oracle query optimizer about your data, the
> > process for doing which involves so many complicated decisions that
> > probably few people will really ever do it very well.
>
>
> Do you see any future developments in this area besides the usual "we
> won't need dbas in the next release, it's all self-tuning and self-
> administered"?

I don't know of any. I think it's a fertile field for some Oracle partner to invent something fantastically clever and helpful.

Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Nullius in verba  

Hotsos Symposium 2007 / March 4-8 / Dallas Visit www.hotsos.com for curriculum and schedule details...

--
http://www.freelists.org/webpage/oracle-l