Vbulletin ALL fields NOT NULL a good thing?

Is the Vbulletin ALL fields NOT NULL a good thing?

Does it bring a performance benefit?

thanks

Always use NOT NULLS, IMO.

Example: Using NOT NULLS

ID/Name
1 / Joe
2/ << Nothing in a NOT NULL column
3/ Bob

SELECT ID FROM table WHERE name<>'Joe'

returns,
2, 3

Same if table allows NULLs
ID/Name
1 / Joe
2/ << NULL in a NULL column
3/ Bob

SELECT ID FROM table WHERE name<>'Joe'

returns
3

ONLY

NULL fields aren't checked as part of select statements. This can produce unexpected (though logically correct) results.