Example of a Sybase composite index
Example of a Sybase composite index |
|
For example, to create an composite index called zipidx on a column called zip and a column called number in a table called rolodex, type
create index zipidx on rolodex (zip,number)
go
If you see
Msg 1906, Level 16, State 1
Server '', Line 1
Cannot create an index on table 'oanda', because this table
does not exist in database 'pubs2'.
you have tried to index a table that doesn't exist. Most likely,
you mis-typed the table name. Run your index command again,
making sure to type the right table name.
If you see
Msg 1919, Level 16, State 1
Server '', Line 1
Column 'first_name' -- Can't create index on a column
of TEXT or IMAGE datatype.
Msg 1919, Level 16, State 1
Server '', Line 1
Column 'last_name' -- Can't create index on a column
of TEXT or IMAGE data type
you've tried to create an index on a column with text of image as
its datatype. That's not allowed, try another column.