Posted by Alexander Kuznetsov on 12/07/05 05:17

Paul,

besides using an indexed view, which may be a little bit tricky, you
could create your own table:

SELECT pkcol
FROM tbl
into side_table
WHERE yourcolumn = 'Showed'

of course you will have to maintain the table manually, via triggers.

[Back to original message]