>> Are NULLs stored in an index? I believe not.
>
> Of course it is stored. And IS NULL could be evaluated using index.

OK, Vlad, thanks, I thought that specifically this couldn't
be evaluated using an index.

Thanks for clearing that up.

With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!