Sybase 12.4.2 manual Performance issues, 352

Performance issues

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

352