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
-- There will allwasy be another 10 last bugs --
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Carel-Jan 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).
