Re: Adding Indexes to New Columns

Posted in 1994

"Paul Hatcher" — Mon, 23 May 1994 09:01:35 GMT — source: Informix-list mailing list archive (1991-1998)

I think the problem in your case is the fact that NULL values *don't* get indexed - so it would have to do a linear scan of the database. This is one of the reasons that default values for columns are useful. Paul Hatcher Graduate Associates Ltd +44 81 840 3110 - Phone phatcher@cix.compulink.co.uk +44 81 567 1894 - Fax