Project

General

Profile

« Previous | Next » 

Revision 2636

schemas/functions.sql: Added indexes on all relational function parameters since the unique index will not be used for lookups

View differences:

schemas/functions.sql
288 288

  
289 289

  
290 290
--
291
-- Name: _alt_0; Type: INDEX; Schema: functions; Owner: -; Tablespace: 
292
--
293

  
294
CREATE INDEX _alt_0 ON _alt USING btree ("0");
295

  
296

  
297
--
298
-- Name: _alt_1; Type: INDEX; Schema: functions; Owner: -; Tablespace: 
299
--
300

  
301
CREATE INDEX _alt_1 ON _alt USING btree ("1");
302

  
303

  
304
--
305
-- Name: _alt_2; Type: INDEX; Schema: functions; Owner: -; Tablespace: 
306
--
307

  
308
CREATE INDEX _alt_2 ON _alt USING btree ("2");
309

  
310

  
311
--
312
-- Name: _alt_3; Type: INDEX; Schema: functions; Owner: -; Tablespace: 
313
--
314

  
315
CREATE INDEX _alt_3 ON _alt USING btree ("3");
316

  
317

  
318
--
319
-- Name: _alt_4; Type: INDEX; Schema: functions; Owner: -; Tablespace: 
320
--
321

  
322
CREATE INDEX _alt_4 ON _alt USING btree ("4");
323

  
324

  
325
--
326
-- Name: _alt_5; Type: INDEX; Schema: functions; Owner: -; Tablespace: 
327
--
328

  
329
CREATE INDEX _alt_5 ON _alt USING btree ("5");
330

  
331

  
332
--
333
-- Name: _alt_6; Type: INDEX; Schema: functions; Owner: -; Tablespace: 
334
--
335

  
336
CREATE INDEX _alt_6 ON _alt USING btree ("6");
337

  
338

  
339
--
340
-- Name: _alt_7; Type: INDEX; Schema: functions; Owner: -; Tablespace: 
341
--
342

  
343
CREATE INDEX _alt_7 ON _alt USING btree ("7");
344

  
345

  
346
--
347
-- Name: _alt_8; Type: INDEX; Schema: functions; Owner: -; Tablespace: 
348
--
349

  
350
CREATE INDEX _alt_8 ON _alt USING btree ("8");
351

  
352

  
353
--
354
-- Name: _alt_9; Type: INDEX; Schema: functions; Owner: -; Tablespace: 
355
--
356

  
357
CREATE INDEX _alt_9 ON _alt USING btree ("9");
358

  
359

  
360
--
291 361
-- Name: _alt_unique; Type: INDEX; Schema: functions; Owner: -; Tablespace: 
292 362
--
293 363

  
......
295 365

  
296 366

  
297 367
--
368
-- Name: _label_label; Type: INDEX; Schema: functions; Owner: -; Tablespace: 
369
--
370

  
371
CREATE INDEX _label_label ON _label USING btree (label);
372

  
373

  
374
--
298 375
-- Name: _label_unique; Type: INDEX; Schema: functions; Owner: -; Tablespace: 
299 376
--
300 377

  
......
302 379

  
303 380

  
304 381
--
382
-- Name: _label_value; Type: INDEX; Schema: functions; Owner: -; Tablespace: 
383
--
384

  
385
CREATE INDEX _label_value ON _label USING btree (value);
386

  
387

  
388
--
389
-- Name: _merge_0; Type: INDEX; Schema: functions; Owner: -; Tablespace: 
390
--
391

  
392
CREATE INDEX _merge_0 ON _merge USING btree ("0");
393

  
394

  
395
--
396
-- Name: _merge_1; Type: INDEX; Schema: functions; Owner: -; Tablespace: 
397
--
398

  
399
CREATE INDEX _merge_1 ON _merge USING btree ("1");
400

  
401

  
402
--
403
-- Name: _merge_2; Type: INDEX; Schema: functions; Owner: -; Tablespace: 
404
--
405

  
406
CREATE INDEX _merge_2 ON _merge USING btree ("2");
407

  
408

  
409
--
410
-- Name: _merge_3; Type: INDEX; Schema: functions; Owner: -; Tablespace: 
411
--
412

  
413
CREATE INDEX _merge_3 ON _merge USING btree ("3");
414

  
415

  
416
--
417
-- Name: _merge_4; Type: INDEX; Schema: functions; Owner: -; Tablespace: 
418
--
419

  
420
CREATE INDEX _merge_4 ON _merge USING btree ("4");
421

  
422

  
423
--
424
-- Name: _merge_5; Type: INDEX; Schema: functions; Owner: -; Tablespace: 
425
--
426

  
427
CREATE INDEX _merge_5 ON _merge USING btree ("5");
428

  
429

  
430
--
431
-- Name: _merge_6; Type: INDEX; Schema: functions; Owner: -; Tablespace: 
432
--
433

  
434
CREATE INDEX _merge_6 ON _merge USING btree ("6");
435

  
436

  
437
--
438
-- Name: _merge_7; Type: INDEX; Schema: functions; Owner: -; Tablespace: 
439
--
440

  
441
CREATE INDEX _merge_7 ON _merge USING btree ("7");
442

  
443

  
444
--
445
-- Name: _merge_8; Type: INDEX; Schema: functions; Owner: -; Tablespace: 
446
--
447

  
448
CREATE INDEX _merge_8 ON _merge USING btree ("8");
449

  
450

  
451
--
452
-- Name: _merge_9; Type: INDEX; Schema: functions; Owner: -; Tablespace: 
453
--
454

  
455
CREATE INDEX _merge_9 ON _merge USING btree ("9");
456

  
457

  
458
--
305 459
-- Name: _merge_unique; Type: INDEX; Schema: functions; Owner: -; Tablespace: 
306 460
--
307 461

  
......
309 463

  
310 464

  
311 465
--
466
-- Name: _nullIf_null; Type: INDEX; Schema: functions; Owner: -; Tablespace: 
467
--
468

  
469
CREATE INDEX "_nullIf_null" ON "_nullIf" USING btree ("null");
470

  
471

  
472
--
473
-- Name: _nullIf_type; Type: INDEX; Schema: functions; Owner: -; Tablespace: 
474
--
475

  
476
CREATE INDEX "_nullIf_type" ON "_nullIf" USING btree (type);
477

  
478

  
479
--
312 480
-- Name: _nullIf_unique; Type: INDEX; Schema: functions; Owner: -; Tablespace: 
313 481
--
314 482

  
......
316 484

  
317 485

  
318 486
--
487
-- Name: _nullIf_value; Type: INDEX; Schema: functions; Owner: -; Tablespace: 
488
--
489

  
490
CREATE INDEX "_nullIf_value" ON "_nullIf" USING btree (value);
491

  
492

  
493
--
319 494
-- Name: _alt; Type: TRIGGER; Schema: functions; Owner: -
320 495
--
321 496

  
schemas/py_functions.sql
188 188

  
189 189

  
190 190
--
191
-- Name: _dateRangeEnd_value; Type: INDEX; Schema: py_functions; Owner: bien; Tablespace: 
192
--
193

  
194
CREATE INDEX "_dateRangeEnd_value" ON "_dateRangeEnd" USING btree (value);
195

  
196

  
197
--
191 198
-- Name: _dateRangeStart_unique; Type: INDEX; Schema: py_functions; Owner: bien; Tablespace: 
192 199
--
193 200

  
......
195 202

  
196 203

  
197 204
--
205
-- Name: _dateRangeStart_value; Type: INDEX; Schema: py_functions; Owner: bien; Tablespace: 
206
--
207

  
208
CREATE INDEX "_dateRangeStart_value" ON "_dateRangeStart" USING btree (value);
209

  
210

  
211
--
212
-- Name: _namePart_first; Type: INDEX; Schema: py_functions; Owner: bien; Tablespace: 
213
--
214

  
215
CREATE INDEX "_namePart_first" ON "_namePart" USING btree (first);
216

  
217

  
218
--
219
-- Name: _namePart_last; Type: INDEX; Schema: py_functions; Owner: bien; Tablespace: 
220
--
221

  
222
CREATE INDEX "_namePart_last" ON "_namePart" USING btree (last);
223

  
224

  
225
--
226
-- Name: _namePart_middle; Type: INDEX; Schema: py_functions; Owner: bien; Tablespace: 
227
--
228

  
229
CREATE INDEX "_namePart_middle" ON "_namePart" USING btree (middle);
230

  
231

  
232
--
198 233
-- Name: _namePart_unique; Type: INDEX; Schema: py_functions; Owner: bien; Tablespace: 
199 234
--
200 235

  

Also available in: Unified diff