Index

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

509

Page 529
Image 529
Sybase 12.4.2 manual 509, See Also stored