Tom: >OK Karen. I know I under slept last night and maybe that's the reason >your good advice is not hitting the meat... ...are unindexed queries >against views faster?
>If so, why? Got me hanging!!! I have no idea! And I don't think we can make a blanket statement just based on this experience. The only difference I could see between the fast statement and the never-ending statement was that the fast statement wasn't using an index. So I forced the slow one to not use an index by using the parenthesis, and all of a sudden it was fast. I would love to hear from someone why it would be faster without an index. In the meantime I'd suggest that anyone who has a really slow view and you're selecting based on an indexed column, go ahead and try an un-indexed search for the heck of it! Karen ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
