Here's a wild guess. If the character set is changed, a 10 MB segment (from the first extent to high water mark) may become 20 MB or 5 MB. Then CBO changes the plan and it happens to be a bad one.
Yong Huang --- Carel-Jan <[EMAIL PROTECTED]> wrote: > At 10:34 17-11-03 -0800, you wrote: > > >Performance depends on a lot of things, such how much string operations you > >got, what are the contents of your strings (are they mainly latin chars or > >are there lots of asian ones etc..). > > > >Tanel. > > Thanks Tanel for your respond. I doubt whether a query will go from several > minutes to seconds, even when a fixed-width single-byte characterset is > chosen. I'm not supposed to interfere with this Service Desk project, but > just couldn't keep my mouth shut when I heard HP scheduled a meeting for > tomorrow (when I'm not there) and claimed that recreation of a database > with the proper characterset would do the job. I suggested to do some > tracing & analysis first, before start shooting at a moving target in the > dark. And of course posted the question to this bunch of knowledgable people. > > > Regards, Carel-Jan __________________________________ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yong Huang INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).