Quote:
Originally Posted by Mad Mel
I'd use an OLAP cube to filter the clue dimension.
|
I'm no DBA, but I think the most efficient and simplest way to tackle this problem is to create a table called Users_With_Clue (and move Clue into that table) and do an inner join against the Users table. As the Users_With_Clue table will always be empty, you'll get the fastest execution times on that SELECT statement plus save the overhead of having to maintain the index. You'll also save all that space you're wasting storing all those zero values, for that matter.
I'm sure this is why the Hooters waitress was confused by the shirt.