Does the SETting for "MANOPT" have any role here? Isn't there also a means to analyze query processing in RB?
With that message about '<>', I'll be checking some code that I wish would run faster. Later, Steve in Memphis > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On > Behalf Of Alastair Burr > Sent: Saturday, April 13, 2002 9:39 AM > To: [EMAIL PROTECTED] > Subject: Re: Using index is slower > > > 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/ > ================================================ 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/
