Sybase 12.4.2 User Manual
Page 528
Index
508
P
page size
111
Catalog 37
switch 37
paging
effect on performance
420
memory 420
monitoring on UNIX
477
monitoring on Windows NT
477
Parallel CREATE INDEX
139
partial-width insertions
about 197
rules 198
START ROW ID option
194
partial-width inserts
examples 199
partitions
definition 441
password
default 354
Password connection parameter
about 73
passwords
changing 11,
357
ODBC configuration
69
pathnames
for databases
109
performance
ad hoc joins
149
balancing I/O
441
benefits of denormalizing databases
455
choosing correct index type
452
definition 419
designing for
419
disk caching
451
effect of constraints
274
impact of versioning
309
indexes 132
inserts 192
loading
data 221
loading from flat files
205
monitoring 467
multi-user 450
procedures 230
RAM disk use
452
restricting queries with iqgovern
448
performance monitor
examples 473
performance tuning
introduction 465
permissions
command-line switches
36
conflicts 372
connect 357
DBA authority
354
external procedures
269
granting passwords
357
group 363
group
membership 364
groups 356,
365
in Sybase Central
360, 361
individual 356
inheriting
360, 363
INSERT and DELETE, on views
371
listing 374
managing 353
overview 353
passwords 357
procedures 233,
361
RESOURCE authority
355, 358
tables 355,
359
the right to grant
360
types
of 4
user-defined functions
237
views
130, 359
WITH GRANT OPTION
360
ping
testing Open Client
487
PIPE_NOT_CONNECTED error
179
plug-ins
connecting 49
port number
default 55
specifying on NT
56
specifying on UNIX
55
port numbers
TCP/IP 490
Port option
introduction 490
PREFETCH_BUFFER_LIMIT
option 450
Prefetched cache pages
450
PREVIEW option