Filter
Top Products
Index
509
LOAD TABLE statement 184
primary keys
creating 125
entity integrity 283
inserting data 196
order of columns 126
retrieving information 11
unenforced multi-column 126
priority
lowering 450
privileges
defining database objects 103
for inserting and deleting 173
procedures
about 229
benefits of 230
calling 232
command delimiter 265
creating 231
cursors 251
cursors in 253
dates and times 266
default error handling 256
dropping 232
error handling 255
exception handlers 261
EXECUTE IMMEDIATE statement 264
execution permissions 233
external 268
multiple result sets from 250
owner 355
parameters 244, 245
performance 230
permissions 361
permissions for creating 355
result sets 234, 249
returning results 246, 247
returning results from 233
savepoints in 265
security 369
See Also stored 7
SQL statements allowed in 243
structure 243
system 7
table names 266
using 230
variable result sets from 250
verifying input 267
warnings 260
writing 265
process threading model 439
protocols
switch 38
ps command
monitoring CPUs on UNIX 479
PUBLIC group 367
PWD connection parameter
about 73
Q
qualified object names 367
queries
concurrency rules 299
indexing recommendations 452
limiting concurrent 34
optimizing 457, 458
restricting concurrent 448
restricting memory use 449
structuring 456
query plans 457
query types
index types for 141
QUERY_DETAIL option 457
QUERY_INFORMATION option 457
QUERY_TEMP_SPACE_LIMIT option 449
QUERY_TIMING option 458
questions
character sets 316
quotation marks
in SQL 368
QUOTED_IDENTIFIER option
Open Client 491
R
RAM disk memory 452
raw devices
effect on performance 441
raw partitions