Re: Index not used when UNICODE = true?
Tech-Archive recommends: Fix windows errors by optimizing your registry
Markus,
How is the table defined? If the table column is unicode, then the index on
it is unicode and all should be fine when searching for unicode data.
However, if the column and index is not unicode, then searching with
unicode=false should faster.
If you get the table definition, you should see something like one of the
following:
CREATE TABLE dbo.MyTable
(KeyColumn INT,
NonUnicodeData VARCHAR(1000),
UnicodeData NVARCHAR(1000)
);
Your query should match the datatype of the column (and its index) that you
are searching.
FWIW,
RLF
"MarkusM." <MarkusM@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:440941DF-A00A-49D9-A42A-2AE32F58B89B@xxxxxxxxxxxxxxxx
Hello,
we've an Java application which select some records from SQL Server 2005.
If
connection parameter unicode is active, every select executes an full
table
scan an the app is very slow (> 1hour). After changing unicode=false, the
index is used and executing is processed in seconds.
Has someone an idea for this problem?
--
Markus M.
Softwareentwickler/Software Developer
.
Relevant Pages
- Re: Unicode Problem with Word 2003 - Help required from knowledgeable MVPs
... representation of the Unicode number, ... dialog never shows you anything but the *hexadecimal* representation. ... focus jump back to the space character. ... For example, if you're searching for a Hebrew alef, ...
(microsoft.public.word.application.errors) - Re: Linking Libs on WinCE 6, x86
... One last question (and then I promise to leave you both alone) - My ... application is now being built as Unicode and searching for the ...
(microsoft.public.windowsce.app.development) - Re: Any component for Unicode for window 98 and Win2k
... access of my application (Chinese GB or Big 5 and English). ... I want to use dtsearch for document searching word or Excel or PDF. ... library need unicode for searching. ... > API functions enabling a single-source Unicode code base to access the ...
(borland.public.delphi.thirdpartytools.general) - Yet another unicode question: windows platform
... I'm still searching for the answer but I can't find it yet so maybe ... reading MS SQL Server errorlog file- sql7 and sql2000 are standard ... now the file is in unicode format. ... talks about writing but I was able to use the same concept to read the ...
(perl.beginners) - Re: Big widget problems from perl 5.6 to 5.8
... just glancing at the error, half awake here, but this seems to be a invalid ... Searching the web deeply, I found something telling that it is a know bug from perlapp (unicode in temp path gets the script to fail working). ...
(comp.lang.perl.tk) |
|
