I have a database where one of the common queries is has a "where blobCol is null", I think that this is getting bad performance (as in a full table scan). I have no need to index the contents of the blobCol.
What indexes would improve this? Can an index be built on an expression (blobCol is not null) rather than just a column?
Multiple FKs with ON DELETE CASCADE to the same table (MSSQL2008)
Sanity Check: Floats as primary keys?
Sqlite binding within string literal
It seems that the best you could do on SQL Server though is to create a computed column that, for example, will contain 1 if blob is null and 0 otherwise and create an index over that..
CREATE INDEX notNullblob ON myTable (blobCol is not NULL);
what characters should be escaped in sql string parameters
combobox and text input
Dynamic SQL to load images from a directory
converting from string to date in VBA and clearing old SQL data output for automation program
What to use in SQL instead of a “Foreach” loop