Karen / Tom If the table(s) on which the view is based are indexed then _maybe_ there is some sort of conflict if R:Base tries to index everything and it just works faster the simpler the query is.
It would be nice to know from "the experts", though. Regards, Alastair. ----- Original Message ----- From: "tellef" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, April 13, 2002 2:25 PM Subject: Re: Using index is slower > 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/ ================================================ 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/
