Sybase 12.4.2 manual 503

Index

types of 16

G

global temporary tables
about	120
gm switch	34
effect on recovery				308
GRANT statement
creating groups			363
DBA authority			358
group membership				364
new users		357
passwords		357
permissions		359
procedures		361
RESOURCE authority					358
WITH GRANT OPTION					360
without password				366
GROUP BY clause
impact on index choice					141
GROUP permissions
not inheritable			363
groups
adding with sp_addgroup					10
changing membership 10
creating	363
dropping		10
managing		363
membership			364
permissions		356, 365
PUBLIC		367
Sybase Central			364
SYS 367
without passwords				366

H

HG index
advantages	147
comparison to other indexes 147
disadvantages	147

recommended use 146 HG index

additional indexes		147
High_Group index
See HG index
High_Non_Group index
See HNG index
HNG index	148
additional indexes		149
advantages	148
comparison to other indexes 149
disadvantages 148
recommended use		148
hold cursors	297, 313

I

I/O
performance recommendations					441
identifiers
case insensitivity		322
international aspects			322
IF statement
syntax	239
importing
from pre-Version 12 IQ databases					193
importing data
conversion errors		220
from Adaptive Server Enterprise					192
LOAD TABLE statement				175
in LOAD TABLE		213
index types
about	135
choosing for performance				452
criteria for choosing			140
LF 145
recommendations		142
selecting 150
INDEX_PREFERENCE option				458
Indexes
parallel creation		139
indexes
about	135
adding after loading tables				151
adding and dropping			137
created automatically			121
creating	138

503