Sybase 12.4.2 - Manual (Page 523)

Index
503
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