TOPIC | 179.0 | Optimizer again (sigh...) |
| 179.3 | Thu Sep 14 1989 14:21 | it's not optimizer | 20 lines |
TOPIC | 284.0 | seq. retrieval with comp.keys |
| 284.1 | Wed Oct 04 1989 12:18 | This may help | 13 lines |
| 284.3 | Fri Oct 06 1989 16:46 | SPR? | 7 lines |
TOPIC | 385.0 | Are we supposed to *ever* use the CROSS clause ? |
| 385.3 | Wed Oct 25 1989 13:35 | CROSS is good but not sometimes | 12 lines |
TOPIC | 449.0 | Optimizer question (benchmark against Oracle) |
| 449.6 | Tue Nov 07 1989 10:54 | Index-only is the answer | 21 lines |
| 449.11 | Tue Nov 07 1989 14:41 | Sorry for misinterpretation | 23 lines |
| 449.15 | Wed Nov 08 1989 10:39 | Uses hybrid approach | 9 lines |
| 449.23 | Thu Nov 09 1989 15:44 | Other exceptions to key-only boolean | 5 lines |
TOPIC | 455.0 | hashing efficient for CROSSes ? |
| 455.5 | Wed Nov 08 1989 11:11 | | 8 lines |
| 455.7 | Wed Nov 08 1989 11:27 | | 17 lines |
TOPIC | 580.0 | Optimizer strategy with concatenated index fields |
| 580.1 | Tue Dec 05 1989 13:57 | some answers | 24 lines |
TOPIC | 588.0 | Testing Host Variables in Query |
| 588.1 | Wed Dec 06 1989 13:29 | may hurt performance | 19 lines |
TOPIC | 765.0 | View performance again |
| 765.4 | Fri Jan 19 1990 13:29 | It's a known problem | 18 lines |
| 765.6 | Mon Jan 22 1990 12:24 | | 11 lines |
TOPIC | 766.0 | Limitation on number of relations to join? |
| 766.5 | Fri Jan 19 1990 13:05 | Limit is 32, views or no views | 8 lines |
TOPIC | 781.0 | How to find the record that's causing NO_DUP error |
| 781.1 | Fri Jan 19 1990 12:49 | SQL group by will do it | 10 lines |
TOPIC | 26.0 | RDB$CARDINALITY values for system tables |
| 26.1 | Fri Mar 16 1990 11:04 | It's 0 for unique indexes | 11 lines |
TOPIC | 109.0 | Unexpected results for SQL Select query |
| 109.3 | Wed Mar 28 1990 13:10 | Please post strategies | 1 lines |
| 109.6 | Wed Mar 28 1990 14:54 | Please try this | 11 lines |
| 109.9 | Wed Mar 28 1990 15:49 | Please SPR it | 10 lines |
TOPIC | 142.0 | VIEW PERFORMANCE PROBLEM ON TWO SIMILAR DATABASES |
| 142.1 | Mon Apr 02 1990 13:52 | No right index? | 16 lines |
| 142.3 | Mon Apr 02 1990 16:34 | | 11 lines |
| 142.5 | Wed Apr 04 1990 15:14 | | 14 lines |
TOPIC | 156.0 | rdms$$rss$asn_for_rss$ndx bugcheck ??? |
| 156.2 | Wed Apr 04 1990 13:59 | Fixed in next release | 4 lines |
| 156.3 | Wed Apr 04 1990 15:16 | Fixed in V3.1B | 5 lines |
TOPIC | 263.0 | table cardinality updates |
| 263.1 | Wed Apr 25 1990 13:26 | It depends | 21 lines |
TOPIC | 264.0 | Can Rdb limit oversized queries |
| 264.1 | Wed Apr 25 1990 12:28 | It's question of priority | 6 lines |
TOPIC | 273.0 | RDSBUGCHK: SETUP_FOR_NO_GET |
| 273.6 | Tue May 01 1990 16:24 | Reorder fields | 9 lines |
TOPIC | 274.0 | Optimize SW and Containing? |
| 274.8 | Mon Apr 30 1990 12:57 | PLACEMENT VIA can make a big difference | 24 lines |
| 274.10 | Mon Apr 30 1990 17:19 | Partitioned or otherwise | 10 lines |
TOPIC | 299.0 | Rdb 3.0B View Problem |
| 299.1 | Wed May 02 1990 12:42 | You are not joining tables | 7 lines |
TOPIC | 302.0 | VIEW PERF with SUM & GROUP_BY |
| 302.1 | Thu May 03 1990 12:55 | Try this and let us know | 26 lines |
| 302.3 | Thu May 03 1990 16:01 | | 13 lines |
| 302.6 | Fri May 04 1990 17:02 | Something is missing here | 24 lines |
TOPIC | 346.0 | nested select, not in, version 3.1a |
| 346.1 | Tue May 15 1990 14:23 | Use correlated subquery | 22 lines |
| 346.4 | Wed May 16 1990 12:19 | Please SPR it | 7 lines |
| 346.5 | Wed May 16 1990 18:04 | It's because ANSI SQL | 29 lines |
TOPIC | 468.0 | Performance problem with modifying an indexed field |
| 468.2 | Fri Jun 08 1990 16:57 | One more possibility | 7 lines |
TOPIC | 484.0 | Index dilemma |
| 484.1 | Tue Jun 12 1990 17:02 | More info | 6 lines |
TOPIC | 530.0 | CROSS is not using HASED INDEX |
| 530.4 | Tue Jun 19 1990 13:13 | It's SPR time | 4 lines |
TOPIC | 541.0 | Optimizer behaviour with view and index |
| 541.1 | Wed Jun 20 1990 12:18 | | 5 lines |
TOPIC | 549.0 | check_for_ccols_in_ndx + accvio in bugcheck on invoke |
| 549.1 | Fri Jun 22 1990 12:38 | Upgrade to V3.1B | 5 lines |
TOPIC | 855.0 | Views and optimizer |
| 855.1 | Wed Aug 15 1990 13:38 | SPR it please | 14 lines |
TOPIC | 863.0 | Bugcheck at RDMS$$NDX_CHECK_UPDATE + 5B |
| 863.3 | Thu Aug 16 1990 12:55 | Rearranging table columns may help | 11 lines |
| 863.5 | Fri Aug 17 1990 16:46 | Don't know | 9 lines |
TOPIC | 871.0 | Optimizer problem |
| 871.1 | Thu Aug 16 1990 17:56 | Compare BLR's | 5 lines |
TOPIC | 932.0 | Optimizer again |
| 932.6 | Mon Sep 10 1990 16:19 | fixed in V4.0 | 6 lines |
TOPIC | 939.0 | First n in view doesn't return row based on outer RSE |
| 939.6 | Fri Sep 14 1990 15:54 | SPR please | 16 lines |
TOPIC | 950.0 | Problem with constraint and missing |
| 950.3 | Fri Sep 07 1990 17:39 | MISSING values are not restricted | 9 lines |
TOPIC | 1020.0 | CONSTRAINTS & MISSING VALUE |
| 1020.2 | Mon Sep 17 1990 13:46 | Allows nulls by default | 10 lines |