On Thu, 2005-06-09 at 11:57 -0600, kirk wrote: > I have also read that allowing a field to be NULL slows down your > queries.
I doubt that it would change anything unless that field is a Primary Key or a Foreign Key. Most PKs are really just a field that is "NOT NULL" and Unique (requires an index), so that would take care of any NULLs getting in there. As for indexing on the FK or any other field, I guess you would have to know how the index was being made. I'm sure NULLs effect each strategy differently. Gabe .===================================. | This has been a P.L.U.G. mailing. | | Don't Fear the Penguin. | | IRC: #utah at irc.freenode.net | `==================================='
