Arne Gehlhaar wrote.:

...
> By the way, what about the performace for string compares 
> (str1 = str2) 
> or (str1 like 'xzy%') for unicode columns? Is there a difference? Can 
> unicode columns be indexed?

Comparison is done byte per byte --> twice the number of bytes have to
be compared. 

like works as usual, but of course has to handle twice the number of bytes

Of course can unicode-columns be indexed.
Everything (except LONG) not exceeding the length of 1024 bytes can be indexed.

Elke
SAP Labs Berlin
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general

Reply via email to