Try using index hints in the stored procedure to force the stored procedure to always use those indexes regardless of whether the statistics are up to date.
I have noticed this phenomenon on several occasions. And in fact, it happens in other databases as well like Oracle and IBM DB2. Unfortunately, I have never found an...
One basic database design principle is to make things as "granular" as possible. Following this design pattern would mean that you would go with the separate bit columns for...