Filter
Top Products
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