Re: performance impact of index

Niall Litchfield wrote:

> err and I've never yet met a read only database with data that never ever
> ever changed, and if I did I'd suspect it was unnecessary.

I have. Well I won't say it never changed. But it only changed once every 24 hours. Or once every month. Or the few tables that did change were stored in a different tablespace.

So as a purist you are probably correct. But as a practical matter I'd have to demure.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)