Sybase Adaptive Server IQ 12.4.2, Administration And Performance Manual

Page: 372 / 536

Performance issues
352
With these options, uppercase characters precede all lowercase characters in
the collation sequence. For example, ’XYZ’ sorts before ’abc’ with these
options, just as it did in older versions of Adaptive Server IQ.
Performance issues
Performance for character data is better with a binary character set and
collation sequence than with a non-binary one.
To maximize performance, create a database with these default option settings:
CREATE DATABASE dbname
COLLATION ’ISO_BINENG’
CASE RESPECT
These options result in a binary character set and collation sequence. All other
settings for these two options form a non-binary character set and collation
sequence.
The disadvantage of these settings is that uppercase characters are always
sorted before lowercase ones. For example, BANANA sorts before apple. If
you prefer a more natural sort order, but still need a case sensitive database, and
you are willing to sacrifice some degree of performance, use the collation
ISO_1 instead of the default, ISO_BINENG.
Note
When your database uses the
CASE RESPECT
option, your user ID and
password become case sensitive. This means that you must enter them as they
have been defined, and the DBA’s user ID and default password must be
entered in uppercase. For example, you could enter the
CONNECT
statement as
follows:
connect database dbasiq user DBA identified by SQL
You would not be able to connect if you entered this statement as:
connect database dbasiq user dba identified by sql