> Under these circumstances there would be a variety of self-joins and various > other queries that would perform the same function as the added flag and > index. You guys feel that this is more efficient? I'm do database guru, but a single bit that's set once at message insertion time and an index to look up those blocks sure sounds more efficient than having the rdbms plan and performing those joins for every single query...
-- Jesse Norell [EMAIL PROTECTED] is not my email address; change "administrator" to my first name. --