Sybase 12.4.2 User Manual

Page 529

Advertising
background image

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

Advertising