[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Posting history for user NOVA::MOHAMED

342 notes across 9 conferences

Known Personal Names (1)

two + two = five

Possible 4 Other Accounts for NOVA::MOHAMED

Username	Total Posts	First Post	Last Post	Most Used Personal Name
7SIGMA::MOHAMED	1	`Thu Sep 27 1990`	`Thu Sep 27 1990`	two + two = five
ARSHIA::MOHAMED	51	`Thu Sep 14 1989`	`Mon Sep 17 1990`	two + two = five
BANZAI::MOHAMED	6	`Wed Sep 13 1989`	`Fri Sep 28 1990`	two + two = five
NOVA::ZMOHAMED	9	`Mon Apr 01 1996`	`Tue May 21 1996`	two + two = five

Summary of Posts

Click on conference filespec to scroll down to

Conference	Total Posts	Conference Title
orarep::nomahs::rdb_40	144	Rdb/VMS - Digital's Strategic Relational Database
orarep::nomahs::rdb_60	76	Oracle Rdb - Still a strategic database for DEC on Alpha AXP!
orarep::nomahs::rdb_31	44	Rdb/VMS V3.1 - first in the 1990's
orarep::nomahs::rdb_50	41	DEC Rdb - Digital's Strategic Relational Database - on Alpha AXP and VAX
orarep::nomahs::rdb_41	17	Rdb/VMS - Digital's Strategic Relational Database - 193.4 TPS
orarep::nomahs::rdb_wish	13	Oracle Rdb Wishes and Suggestions
orarep::nomahs::sql	4	SQL notes
orarep::nomahs::rdb30b	2	VAX Rdb/VMS V3.0B
orarep::nomahs::rdb_30	1	VAX Rdb/VMS

Conference orarep::nomahs::rdb_40 (Rdb/VMS - Digital's Strategic Relational Database)

144 posts

TOPIC	10.0	Guest Registry... (who, where, and why)
	10.3	`Mon Jan 14 1991 17:29`	Zia Mohamed	8 lines
TOPIC	28.0	optimizer wont use INDEX ONLY (3.1)
	28.4	`Fri Jan 18 1991 16:56`	known problem	7 lines
TOPIC	32.0	Constraints evaluation time: verb vs commit
	32.3	`Fri Jan 18 1991 18:29`		53 lines
	32.4	`Fri Jan 18 1991 18:35`		10 lines
	32.7	`Mon Jan 21 1991 12:31`	More clarification	37 lines
	32.9	`Mon Jan 21 1991 17:04`		10 lines
	32.12	`Tue Jan 22 1991 10:01`		12 lines
	32.16	`Wed Jan 23 1991 11:26`		15 lines
	32.18	`Thu Jan 24 1991 12:05`	Yes and No	17 lines
TOPIC	43.0	Data Integrity Question...
	43.4	`Fri Jan 18 1991 18:25`	May this check	13 lines
TOPIC	80.0	Wrong optimizer strategy after upgrade to V3.1B?
	80.1	`Wed Jan 23 1991 11:03`		15 lines
TOPIC	104.0	DynOpt questions
	104.4	`Mon Jan 28 1991 16:40`	Just to make it clearer	16 lines
TOPIC	191.0	Index only or not
	191.2	`Thu Feb 14 1991 14:41`	It's SPR time again	3 lines
TOPIC	218.0	HASH INDEX and Index Only Retrieval ?
	218.6	`Wed Feb 13 1991 17:26`	Not done for hashed index	5 lines
	218.10	`Fri Feb 15 1991 12:10`	Please submit SPR	6 lines
TOPIC	234.0	RDB$DBKEY_LENGTH field in RDB$RELATIONS question
	234.4	`Thu Feb 14 1991 16:18`	More on view dbkey length	15 lines
TOPIC	249.0	DynamOpt question about repeated trace lines
	249.1	`Mon Feb 18 1991 15:38`		5 lines
	249.3	`Wed Feb 20 1991 13:15`	Yes, I get it on first query run	11 lines
TOPIC	261.0	Optimiser confusion (V3.0B)
	261.3	`Tue Feb 19 1991 19:11`		24 lines
TOPIC	281.0	7 Misc Rdb Questions
	281.8	`Mon Feb 25 1991 11:41`	NULL is to SQL what MISSING is to RDO	11 lines
TOPIC	287.0	How are sorted indexes utilized?
	287.4	`Mon Feb 25 1991 11:56`		12 lines
TOPIC	316.0	Dyn Opt Questions
	316.1	`Tue Feb 26 1991 13:57`		30 lines
TOPIC	342.0	existance checking
	342.3	`Fri Mar 01 1991 10:26`	My 2��	8 lines
	342.5	`Mon Mar 04 1991 12:00`	FIRST N <> LIMIT TO n ROWS	16 lines
	342.7	`Tue Mar 05 1991 11:21`		10 lines
TOPIC	347.0	Is there another way to implement an outer join?
	347.3	`Mon Mar 04 1991 11:10`		12 lines
TOPIC	351.0	Constraints vs. unique indexes
	351.1	`Fri Mar 01 1991 18:06`	Some answers	30 lines
	351.3	`Mon Mar 04 1991 14:24`		17 lines
	351.6	`Tue Mar 05 1991 11:15`		11 lines
TOPIC	366.0	Error 0004 - No Name - No Message - SQL SELECT
	366.5	`Fri Mar 08 1991 14:43`	We've some misinformation here	6 lines
TOPIC	372.0	Rdb 3.1B - Delete/Constraint/Performance problem
	372.7	`Fri Mar 15 1991 13:56`		6 lines
TOPIC	443.0	Direct Tree Lookup information needed
	443.1	`Fri Mar 15 1991 15:39`		17 lines
TOPIC	481.0	CHECK_CXPR_LIST_FOR_SNDX with Rdb4.0 IMPORT
	481.3	`Wed Apr 17 1991 14:42`		7 lines
	481.5	`Thu Apr 18 1991 17:43`	Problem in V4.0 but fixed in MNR	6 lines
TOPIC	515.0	Problem accessing view
	515.2	`Tue Mar 26 1991 14:13`		4 lines
TOPIC	520.0	A UNION B changes the strategy of A execution compared to A alone?
	520.2	`Wed Mar 27 1991 10:49`	It may be due to SORT	11 lines
TOPIC	534.0	A Join Strategy Problem
	534.1	`Fri Mar 29 1991 14:38`		4 lines
	534.3	`Thu Apr 04 1991 17:23`	This might work	10 lines
	534.5	`Mon Apr 08 1991 13:47`		12 lines
TOPIC	571.0	Select problem in V4.0?
	571.1	`Fri Apr 05 1991 19:17`		5 lines
	571.2	`Wed Apr 10 1991 15:18`		8 lines
	571.4	`Thu Apr 11 1991 12:36`		7 lines
TOPIC	593.0	Rdb V4.0 performance problems w.r.t V3.1B
	593.2	`Wed Apr 10 1991 15:23`		10 lines
TOPIC	624.0	optimizer ? when using = and START
	624.2	`Mon Apr 15 1991 15:58`		21 lines
	624.4	`Tue May 14 1991 16:52`	Need more details	11 lines
	624.6	`Fri May 17 1991 16:10`	It's inconsistent join cardinality	18 lines
	624.8	`Mon Jun 10 1991 15:36`		51 lines
TOPIC	637.0	SUBSTRING VS. LIKE statment in SQL
	637.4	`Wed Apr 17 1991 14:48`	Available patch(es) may solve this problem	4 lines
TOPIC	684.0	arith_except on a divide by NULL ??
	684.1	`Mon Apr 22 1991 12:17`	It's SPR time again	3 lines
TOPIC	690.0	EXISTS CONSTRAINT - works and doesn't work - why?
	690.4	`Fri Apr 26 1991 18:41`	Constraint evalution is correct	13 lines
TOPIC	719.0	Queries on segmented keys question
	719.9	`Fri Apr 26 1991 12:35`	ORDER BY clause may cure the problem	7 lines
	719.11	`Wed May 01 1991 15:53`		9 lines
	719.14	`Thu May 02 1991 16:33`	Index segment order is still important	47 lines
	719.16	`Tue May 07 1991 18:14`		9 lines
TOPIC	722.0	Outter join and date manipulation?
	722.1	`Fri Apr 26 1991 13:01`	Outerjoin example	23 lines
TOPIC	725.0	Incorrect results on desc. indexes ?
	725.1	`Fri Apr 26 1991 13:12`	Yes, it's SPR time	4 lines
TOPIC	770.0	Optimizer strategy and index node size
	770.1	`Mon May 06 1991 11:58`	No	6 lines
	770.3	`Tue May 07 1991 13:59`	Show old and new index definitions	13 lines
	770.8	`Wed May 08 1991 14:27`		15 lines
TOPIC	776.0	Query returns incorrect results-Serious for Rally
	776.1	`Tue May 07 1991 13:42`		4 lines
TOPIC	782.0	Bad performance with dynamic OR optimization in 4.0
	782.2	`Tue May 07 1991 17:46`		3 lines
TOPIC	804.0	Exception RESTORE_RSS2! Can you comment please?
	804.1	`Fri May 10 1991 13:14`		12 lines
TOPIC	893.0	DEC Professional optimizer article
	893.2	`Fri May 24 1991 12:20`	It's known problem in V4.0	38 lines
TOPIC	896.0	BUILD_CXPR_LIST_FOR_SNDX +18 on OPEN CURSOR
	896.2	`Fri May 31 1991 14:48`		6 lines
TOPIC	923.0	incorrect print with RDB 4.0
	923.6	`Fri May 31 1991 15:10`		4 lines
	923.8	`Mon Jun 10 1991 15:48`	SPR	7 lines
TOPIC	930.0	SUM(a+b) result based on access strategy.
	930.1	`Fri May 31 1991 15:26`		3 lines
	930.3	`Wed Jun 05 1991 13:51`	Yes, this problem was fixed in V4.0	32 lines
TOPIC	958.0	Optimizer changes strategy from one day to the ne
	958.1	`Mon Jun 10 1991 15:46`		7 lines
	958.3	`Tue Jun 11 1991 13:47`	SPR	16 lines
TOPIC	985.0	Index cardinality: ACTUAL >>> STORED
	985.4	`Mon Jun 10 1991 14:02`	Unique index card = table card	18 lines
TOPIC	1005.0	optimizer behaviour for "OR"-queries
	1005.1	`Mon Jun 10 1991 16:25`		10 lines
	1005.3	`Tue Jun 11 1991 14:07`		35 lines
TOPIC	1053.0	MISSING VALUE and CROSS in RDO
	1053.4	`Tue Jun 18 1991 18:15`	It's documented	8 lines
TOPIC	1057.0	RDB V4.0/-1 query got incorrect result.
	1057.3	`Wed Jun 19 1991 14:17`	The output log is incorrect!	11 lines
TOPIC	1066.0	Rdo Erase in large relation = sequential retieval
	1066.1	`Thu Jun 20 1991 14:03`		3 lines
	1066.3	`Thu Jun 20 1991 17:14`		13 lines
TOPIC	1068.0	RMU/VERIFY/CARD discrepancy
	1068.9	`Fri Jun 21 1991 14:01`		13 lines
	1068.11	`Fri Jun 21 1991 17:12`		25 lines
	1068.16	`Mon Jun 24 1991 19:23`		32 lines
TOPIC	1134.0	VERB TIME vs. SQL statement end? - rel. notes 1.4.4
	1134.1	`Tue Jul 02 1991 14:01`	Verb <> SQL statement	6 lines
	1134.3	`Tue Jul 02 1991 15:54`		21 lines
	1134.5	`Wed Jul 03 1991 10:46`		8 lines
	1134.7	`Wed Jul 03 1991 11:55`		8 lines
TOPIC	1143.0	Referential integrity ignores hash index
	1143.1	`Wed Jul 03 1991 10:58`		5 lines
TOPIC	1180.0	views and dbkeys
	1180.3	`Wed Jul 10 1991 17:11`		3 lines
TOPIC	1199.0	Primary Key Constraints - COMMIT takes Long time
	1199.4	`Mon Jul 15 1991 15:20`		4 lines
TOPIC	1214.0	Performance problem with constraint evaluation
	1214.1	`Thu Jul 18 1991 12:31`	This change is documented	12 lines
TOPIC	1245.0	Performance when a table contains 5.5 million rows
	1245.4	`Fri Jul 19 1991 13:59`	Post any indexes on table	7 lines
TOPIC	1278.0	rdb Optimizer confused problem...
	1278.1	`Mon Jul 29 1991 18:41`		3 lines
	1278.5	`Mon Aug 12 1991 12:53`	It's not the optimizer!	18 lines
TOPIC	1283.0	DYNAMIC OPTIMIZER WITH AND
	1283.1	`Mon Jul 29 1991 18:46`	Need more info	4 lines
TOPIC	1332.0	Can YOU do this where DATES are concern?
	1332.2	`Wed Sep 04 1991 13:08`	This might work	9 lines
	1332.4	`Thu Sep 05 1991 12:32`	Quantum mis-leap ;-)	9 lines
TOPIC	1353.0	Another Rdb V4.0 Performance related...
	1353.8	`Wed Aug 07 1991 17:21`		6 lines
	1353.11	`Mon Aug 12 1991 13:02`		10 lines
	1353.13	`Mon Aug 12 1991 19:13`		26 lines
	1353.16	`Wed Aug 14 1991 13:38`		8 lines
	1353.19	`Thu Aug 15 1991 10:38`		22 lines
TOPIC	1354.0	Optimizer not use index in concatenation
	1354.2	`Wed Aug 07 1991 18:32`		5 lines
TOPIC	1363.0	performance problem with UNION ALL
	1363.2	`Fri Aug 09 1991 14:37`		23 lines
	1363.4	`Mon Aug 12 1991 13:44`		17 lines
TOPIC	1372.0	Unique constraint at delete time
	1372.3	`Fri Aug 09 1991 16:50`	SPR	7 lines
TOPIC	1373.0	Poor performance from aggregate function
	1373.1	`Mon Aug 12 1991 13:29`	more info	5 lines
	1373.3	`Mon Aug 12 1991 19:41`		5 lines
TOPIC	1375.0	Question on performance of JOINs
	1375.1	`Mon Aug 12 1991 13:21`	stick with relational joins	35 lines
TOPIC	1383.0	insert trigger behaviour
	1383.2	`Mon Aug 12 1991 13:58`		13 lines
TOPIC	1385.0	generic table driven SQL
	1385.1	`Mon Aug 12 1991 14:16`	Some answers	34 lines
	1385.3	`Mon Aug 12 1991 19:33`		9 lines
TOPIC	1386.0	Union Performance
	1386.3	`Tue Aug 13 1991 12:51`	Rdb will not use indexes	12 lines
TOPIC	1389.0	DIO$FETCH_DBKEY +3F in RDB 4.0
	1389.3	`Wed Aug 14 1991 12:47`		8 lines
TOPIC	1390.0	Updating Views problem
	1390.1	`Mon Aug 12 1991 14:24`	SPR	3 lines
TOPIC	1400.0	order of rows from a cursor
	1400.5	`Tue Aug 20 1991 15:44`		15 lines
TOPIC	1404.0	same BLR for views with/without order by ??
	1404.1	`Wed Aug 14 1991 12:49`		5 lines
TOPIC	1405.0	Dynamic optimization question
	1405.2	`Wed Aug 14 1991 13:00`		11 lines
	1405.4	`Thu Aug 15 1991 11:52`		24 lines
	1405.5	`Thu Aug 15 1991 11:54`	info?	3 lines
	1405.7	`Tue Aug 20 1991 17:52`		18 lines
TOPIC	1415.0	Optimizer takes wrong index
	1415.3	`Thu Aug 15 1991 11:32`		15 lines
TOPIC	1417.0	SQL Cursor vs LIMIT TO retrieval
	1417.5	`Tue Aug 20 1991 14:46`		9 lines
	1417.7	`Wed Aug 21 1991 13:04`	It depends on the query strategy	9 lines
	1417.9	`Wed Aug 21 1991 17:01`		9 lines
TOPIC	1419.0	ORDER BY is not using the index
	1419.1	`Thu Aug 15 1991 17:32`		3 lines
TOPIC	1423.0	processing of views?
	1423.2	`Tue Aug 20 1991 15:14`		35 lines
TOPIC	1430.0	BIND_BUFFERS/BIND_WORK_VM have minimal effect
	1430.4	`Wed Aug 21 1991 13:00`		13 lines
TOPIC	1463.0	RDMS$$EXE_LEAF_CLOSE even with Patch ECO14
	1463.1	`Tue Aug 27 1991 11:14`		4 lines
TOPIC	1464.0	Rdb Locking ?
	1464.1	`Tue Aug 27 1991 11:19`	One source	5 lines
TOPIC	1472.0	Overhead for Hashed writing vs. Update/Delete
	1472.1	`Wed Aug 28 1991 14:14`		12 lines
TOPIC	1484.0	SORT and /STABLE??
	1484.5	`Tue Sep 03 1991 14:43`	You must use SORTED BY clause	15 lines
TOPIC	1487.0	Sequential Search, should use index ?
	1487.2	`Thu Aug 29 1991 15:46`	Need to expand out concatenated columns	26 lines
	1487.6	`Thu Sep 05 1991 12:57`		4 lines
	1487.9	`Mon Sep 09 1991 12:53`	Don't use place via sorted index into uniform area	27 lines
TOPIC	1505.0	outer join in Rdb
	1505.1	`Tue Sep 03 1991 14:58`		14 lines
TOPIC	1525.0	use of index [0:0] on retrieval
	1525.5	`Thu Sep 05 1991 12:19`	Check if stored table card is correct	4 lines
TOPIC	1541.0	IMPORT hanging...appears to be in loop
	1541.7	`Wed Sep 11 1991 16:30`		10 lines
TOPIC	1558.0	constraint evaluation at commit time again
	1558.1	`Tue Sep 10 1991 11:26`	Do not use SQL IN clause in check constraint	16 lines
TOPIC	1570.0	Optimizer selecting wrong index
	1570.3	`Wed Sep 11 1991 16:49`	Known problem	8 lines
TOPIC	1688.0	DISTINCT order and the optimizer
	1688.2	`Thu Oct 24 1991 17:12`		3 lines
TOPIC	1731.0	Optimizer: Index Selection
	1731.11	`Tue Nov 12 1991 14:05`	This is fixed in V4.1	10 lines
TOPIC	1747.0	Why does optimizer user "Sorted Leaf Type"
	1747.3	`Tue Nov 12 1991 14:46`	This may have been fixed in V4.1	12 lines
TOPIC	1757.0	Optimizer chooses index not involved in query...
	1757.2	`Tue Nov 12 1991 15:44`	Not a problem	25 lines
TOPIC	1784.0	Multiple-table delete
	1784.7	`Thu Oct 24 1991 17:08`	Stay away from join update queries	57 lines
TOPIC	2112.0	Lock escalation and the dynamic optimizer
	2112.8	`Wed Jan 15 1992 18:24`	MAX_PAG_BLK_CNT no longer used	15 lines
	2112.10	`Sat Jan 25 1992 14:17`	clarification	25 lines

Conference orarep::nomahs::rdb_50 (DEC Rdb - Digital's Strategic Relational Database - on Alpha AXP and VAX)

41 posts

TOPIC	11.0	Guest Registry... (who, where, and why)
	11.28	`Wed Feb 03 1993 13:00`	Zia Mohamed	7 lines
TOPIC	1541.0	Sequential constraint evaluation since Rdb 5.1
	1541.5	`Wed Oct 13 1993 14:25`	Problem fixed in 5.1A, 6.0	20 lines
TOPIC	1779.0	Constraint evaluation could be more efficient?
	1779.7	`Thu Oct 21 1993 18:42`	Here's some explanation	38 lines
	1779.9	`Fri Oct 22 1993 11:00`	Internal reformatting of foreign key constr	8 lines
TOPIC	1971.0	Hashed + sorted -> suboptimal query performance
	1971.1	`Thu Nov 11 1993 14:06`	Yes, need more info	6 lines
	1971.4	`Fri Nov 19 1993 18:24`	Please submit a QAR	11 lines
TOPIC	2061.0	Optimizer max key lookup strategy
	2061.2	`Wed Nov 24 1993 10:44`	Submit a 4.1 QAR	14 lines
TOPIC	2070.0	Why Rdb fetches Dup.
	2070.5	`Tue Nov 30 1993 16:13`	A good observation!	15 lines
	2070.7	`Fri Dec 03 1993 10:45`	An SPR will also do	13 lines
TOPIC	2131.0	Wrong result on views with 5.1
	2131.8	`Mon Jan 03 1994 13:50`	This SPR has been looked at	11 lines
TOPIC	2201.0	Large query taking a long time to run Rdb V5.1-01
	2201.1	`Fri Dec 17 1993 18:57`		13 lines
TOPIC	2204.0	Optimizer puzzle 4.0/4.2/5.1/6.0
	2204.7	`Fri Dec 17 1993 18:48`	Could it be SORT?	10 lines
TOPIC	2225.0	Retrieve all fields when using DISTINCT on subset?
	2225.1	`Mon Dec 20 1993 18:13`	Would this work?	7 lines
	2225.7	`Tue Dec 21 1993 19:12`	view should do it	15 lines
TOPIC	2248.0	Problems selecting from a view...
	2248.1	`Wed Dec 29 1993 19:00`	more info	4 lines
	2248.3	`Thu Dec 30 1993 18:27`	This problem has been fixed	28 lines
	2248.7	`Mon Jan 03 1994 14:01`	Yes, 2131 = 2248	11 lines
TOPIC	2261.0	Rdb 4.0c spend 5*CPU_time than Rdb 4.0a
	2261.3	`Tue Jan 04 1994 20:09`	Still waiting	4 lines
TOPIC	2270.0	desc index performance
	2270.2	`Tue Jan 04 1994 20:07`	Check with v5.1	3 lines
TOPIC	2297.0	problem when porting a working query from VAX/VMS to OPEN VMS (alpha)
	2297.1	`Mon Jan 10 1994 11:29`	5.1 SPR/QAR please	4 lines
TOPIC	2314.0	Varchar + Collating Seq. + Sorted Index -> No Rows
	2314.2	`Wed Jan 12 1994 19:47`	Might be fixed in v5.1A	4 lines
TOPIC	2331.0	Can insert with values but not with select
	2331.6	`Fri Jan 14 1994 18:18`	second strategy is for store	10 lines
TOPIC	2394.0	New RDMS$$FIND_VALID_SEG_CRTV bugcheck
	2394.1	`Sun Jan 23 1994 11:35`	I'd say MUP is it	10 lines
TOPIC	2457.0	Complete index scan for group_by view select
	2457.2	`Thu Feb 03 1994 20:40`		20 lines
TOPIC	2458.0	Index problem, or optimizer problem ?
	2458.1	`Thu Feb 03 1994 20:26`		3 lines
	2458.3	`Tue Feb 22 1994 11:33`		9 lines
TOPIC	2473.0	Rdb 5.1 index choice
	2473.1	`Thu Feb 03 1994 20:17`		3 lines
	2473.3	`Fri Feb 04 1994 14:17`		19 lines
	2473.5	`Mon Feb 14 1994 11:33`	A better index is needed here	41 lines
TOPIC	2475.0	V5.1AXP:coll.seq. & 'no columns found'
	2475.1	`Tue Feb 08 1994 18:51`		9 lines
TOPIC	2492.0	wrong results with queries/views
	2492.1	`Mon Feb 07 1994 18:57`	Redefine indexes and try	16 lines
	2492.4	`Tue Feb 08 1994 18:46`	Please submit SPR/QAR	7 lines
TOPIC	2541.0	Question about optimiser strategy.
	2541.3	`Tue Feb 15 1994 21:48`	It's potential optimization	13 lines
TOPIC	2598.0	Need help with explaining optimizer strategy
	2598.1	`Wed Feb 23 1994 14:04`	I'd expect this	17 lines
TOPIC	2657.0	different results between 6.0 and 5.1 on AXP
	2657.5	`Fri Mar 04 1994 19:45`	need more info	17 lines
	2657.7	`Tue Mar 08 1994 17:15`		13 lines
TOPIC	2689.0	Query Not Returning Rows With < Operator
	2689.1	`Wed Mar 09 1994 10:01`	more info	4 lines
	2689.4	`Wed Mar 09 1994 17:02`	Are you sure it's the same problem	8 lines
TOPIC	2711.0	RDMSTTBL - very large, multiple versions
	2711.3	`Thu Mar 17 1994 19:03`	Is this the right debug output?	5 lines
TOPIC	2719.0	rdb 5.1 optimizer problem with select and or...
	2719.4	`Tue Mar 15 1994 16:05`	Recently uncovered it	24 lines
	2719.6	`Tue Mar 22 1994 16:48`	Submit a hi prio 5.1 QAR/SPR	13 lines

Conference orarep::nomahs::rdb_60 (Oracle Rdb - Still a strategic database for DEC on Alpha AXP!)

76 posts

TOPIC	23.0	Rdb 5.1 performance problems
	23.5	`Mon May 09 1994 16:11`	It could very well be constraint-related	25 lines
	23.7	`Fri May 20 1994 14:38`	there should be a release note	11 lines
TOPIC	130.0	optimizer problem ?
	130.3	`Thu Apr 07 1994 14:46`	We know this problem	4 lines
TOPIC	135.0	Need help with chosen optimizer strategies
	135.7	`Thu May 12 1994 18:41`	Not a surprise here	29 lines
TOPIC	203.0	4.1A, one index can't return a row
	203.1	`Fri May 13 1994 14:39`	A lost index update?	13 lines
TOPIC	245.0	4 Customer Questions
	245.10	`Fri May 13 1994 15:04`	SPR on use of temp table with delete	25 lines
TOPIC	249.0	ZIG ZAG again
	249.5	`Fri May 13 1994 15:09`		12 lines
TOPIC	259.0	outer join performance
	259.2	`Mon Apr 25 1994 14:10`	Need more info	19 lines
TOPIC	276.0	Why was sequential access not used?
	276.6	`Thu Apr 28 1994 11:55`		7 lines
TOPIC	315.0	Changing the strategy used for DELETEs
	315.3	`Fri May 13 1994 18:28`	I don't see problem here	18 lines
TOPIC	321.0	Uniq cons won't use multi-seg hashed index
	321.5	`Fri May 13 1994 18:37`	Give us more info	12 lines
TOPIC	354.0	Index-Only Retrieval and Hash Indexes
	354.7	`Fri May 13 1994 19:10`	Index only will NOT be used for hashed index	22 lines
TOPIC	382.0	RDMS$$CRTVS_FROM_EOVS and RDMS$$FREE_ECON
	382.3	`Tue Jun 28 1994 12:57`	Test it with ECO2	10 lines
	382.5	`Wed Jun 29 1994 11:48`		16 lines
TOPIC	421.0	Very large RDMSTTBL allocation
	421.4	`Fri May 20 1994 14:56`	Sounds similar	11 lines
TOPIC	445.0	Versions of Rdb
	445.4	`Tue May 17 1994 17:33`	This is not a NIT	7 lines
TOPIC	448.0	LIKE Clause Performance Difference with Smartstar
	448.2	`Wed May 18 1994 14:08`	V6.1 has the answer	14 lines
TOPIC	471.0	different index selection on the same query on 2 twin db
	471.2	`Fri May 20 1994 14:44`	Let's see index cards also	4 lines
	471.4	`Wed May 25 1994 15:06`	Need to clarify	20 lines
	471.6	`Thu May 26 1994 17:13`	Modify the offending index	19 lines
TOPIC	477.0	Trying to understand the optimizer
	477.2	`Fri May 20 1994 15:48`	brief optimizer tutorial	41 lines
TOPIC	502.0	UNIQUE Constraint - education needed ?
	502.5	`Wed May 25 1994 16:01`		4 lines
	502.9	`Tue May 31 1994 12:32`	Use a workaround	42 lines
TOPIC	562.0	Constraint violation that shouldn't be?
	562.3	`Wed Jun 01 1994 12:33`		17 lines
TOPIC	596.0	SELECT ...NOT IN (SELECT...) returns wrong result
	596.3	`Wed Jun 08 1994 12:54`	It's correct behavior	35 lines
TOPIC	598.0	triggers and an index???
	598.1	`Fri Jun 03 1994 16:47`		5 lines
TOPIC	621.0	Constraint failures causing bugchecks?
	621.1	`Wed Jun 08 1994 13:11`	Problem identified	8 lines
TOPIC	629.0	rdms$$crtvs_from_eqvs again
	629.1	`Wed Jun 08 1994 16:35`	see note 621.1	0 lines
	629.5	`Thu Jun 09 1994 11:38`		5 lines
	629.12	`Sun Jun 26 1994 14:32`	ECO2 should do it for you	8 lines
TOPIC	685.0	Problem with limit to clause : number of record returned is not correct
	685.2	`Sun Jun 26 1994 14:18`	I don't see the problem	11 lines
TOPIC	728.0	Why sequental access in this example
	728.1	`Mon Jun 27 1994 15:22`	A restriction	21 lines
TOPIC	742.0	Performance - 5.1
	742.4	`Sun Jun 26 1994 14:51`	Fix must be in an ECO	8 lines
TOPIC	752.0	ACCVIO on lots of ORs
	752.1	`Sun Jun 26 1994 14:58`		11 lines
TOPIC	768.0	PSIISCAN$END_SCAN + E8
	768.3	`Mon Jul 11 1994 16:19`		3 lines
TOPIC	769.0	View on a View ?
	769.1	`Mon Jun 27 1994 17:54`	Could be a known problem	8 lines
	769.3	`Tue Jun 28 1994 13:06`	It's a known problem	18 lines
TOPIC	771.0	RDB-F-NO_RECORD 506:-1:-1 On DELETE Using a DBKEY
	771.1	`Tue Jun 28 1994 12:36`	need more info	24 lines
	771.3	`Wed Jun 29 1994 12:15`	Please test it with higher versions	11 lines
TOPIC	778.0	%RDB-E-READ_ONLY_REL - resurfacing?? on V5.1
	778.1	`Wed Jun 29 1994 11:56`		15 lines
	778.4	`Wed Jun 29 1994 14:55`		9 lines
TOPIC	783.0	Position on Dervived Tables VS Views?
	783.4	`Wed Jun 29 1994 14:42`	No engineering position	11 lines
TOPIC	788.0	Sequential search, where I suppose an index search
	788.1	`Wed Jun 29 1994 14:51`	I don't a problem here	12 lines
	788.3	`Thu Jun 30 1994 14:54`		16 lines
TOPIC	801.0	Rdb 4.1a-eco3, optimizer uses index for a select a,b,c,... from
	801.1	`Thu Jun 30 1994 14:57`		3 lines
	801.3	`Tue Jul 05 1994 16:13`	A known problem	6 lines
TOPIC	813.0	Update and Constraint Checks
	813.1	`Tue Jul 05 1994 19:04`		10 lines
	813.4	`Wed Jul 06 1994 12:28`	ISQL with strategy output will do	7 lines
TOPIC	853.0	Rdb4.1 -> 6.0-1, increased page file needs???
	853.5	`Wed Jul 13 1994 11:44`		17 lines
TOPIC	855.0	Seq scannning of B-tree
	855.1	`Wed Jul 13 1994 11:47`		4 lines
TOPIC	858.0	Formatting problem in interactive SQL
	858.2	`Wed Jul 13 1994 18:07`		4 lines
TOPIC	884.0	%RDB-E-INVALID_BLR
	884.1	`Tue Jul 19 1994 15:29`	Mix of old and new join syntax GOTCHA	7 lines
	884.3	`Fri Jul 22 1994 15:55`	Please enter qar/spr	5 lines
TOPIC	886.0	Hashed index and foreign/primary key constraints
	886.3	`Tue Jul 19 1994 15:43`	We want to do it, BUT	10 lines
	886.6	`Fri Jul 22 1994 16:01`		4 lines
TOPIC	934.0	Query fails in v5.1, but runs wells in 4.1
	934.9	`Wed Jul 27 1994 16:28`	Could be a known problem	8 lines
	934.12	`Thu Jul 28 1994 15:34`	ECO4 most likely should fix your problem	7 lines
TOPIC	947.0	How maintain index SORTED ORDER?
	947.2	`Wed Jul 27 1994 16:38`		11 lines
TOPIC	952.0	Query design for fast first
	952.4	`Sun Jul 31 1994 17:18`	Index-only sort	11 lines
TOPIC	1790.0	Optimizer strategy problem?
	1790.1	`Fri Dec 09 1994 10:14`	Not a known problem	16 lines
TOPIC	1837.0	a question about indices and retrieval
	1837.6	`Fri Dec 16 1994 16:50`	A short tutorial on index usage	49 lines
TOPIC	1852.0	Incorrect data on MIN/MAX
	1852.2	`Wed Dec 21 1994 09:40`	A known problem	8 lines
	1852.5	`Tue Jan 03 1995 11:57`	Bug since v5.0	8 lines
TOPIC	1861.0	PAGE FILE QUOTA CONSUMPTION
	1861.6	`Tue Jan 03 1995 11:54`	Fixed in v6.0 not in v5.1	29 lines
TOPIC	1897.0	V6.0-05 - why is this index used ?
	1897.2	`Wed Jan 04 1995 21:19`	Not a good strategy	3 lines
TOPIC	1899.0	IS NULL is not evaluated as bool in left outer join
	1899.1	`Wed Jan 04 1995 21:14`	We can allow this optimization	30 lines
TOPIC	1920.0	Optimiser 6.0-5 with transitivity and unique indexes
	1920.1	`Mon Jan 09 1995 15:28`		25 lines
	1920.3	`Thu Jan 12 1995 22:04`		18 lines
TOPIC	1956.0	Optimizer/query execution question !
	1956.1	`Thu Jan 12 1995 22:20`		17 lines
	1956.2	`Fri Jan 13 1995 10:22`	Dynamic optimizer is working as documented	15 lines
TOPIC	2450.0	index retrieval work, sequential fails for join
	2450.1	`Wed Apr 19 1995 16:15`	It's the other way around	11 lines
TOPIC	2492.0	%RDB-E-READ_ONLY_REL with RDB 5.1A; with RDB 6.0-5 it works
	2492.2	`Fri Apr 28 1995 11:12`	Ask customer to upgrade to 6.0A	7 lines
TOPIC	2654.0	Outer Join Performance Problem
	2654.3	`Tue Jun 06 1995 11:17`	Need more info	4 lines
TOPIC	2695.0	rdb 6.1-- problem with insert?
	2695.6	`Fri Jun 16 1995 14:29`		24 lines
	2695.8	`Fri Jun 16 1995 15:17`		14 lines
TOPIC	3119.0	Optimizer not using the correct index!
	3119.2	`Mon Sep 18 1995 22:38`	Please submit a bug report	11 lines

Conference orarep::nomahs::sql (SQL notes)

4 posts

TOPIC	1298.0	number of tables in a join
	1298.1	`Mon Oct 08 1990 13:18`		9 lines
TOPIC	1305.0	SQL View, Indices and Performance - Again!
	1305.2	`Mon Oct 08 1990 13:08`	May be due to a known problem	27 lines
	1305.4	`Thu Oct 11 1990 13:43`		5 lines
TOPIC	3647.0	FULL OUTER JOIN
	3647.1	`Mon Oct 09 1995 12:12`	try this out	16 lines

Conference orarep::nomahs::rdb30b (VAX Rdb/VMS V3.0B)

2 posts

TOPIC	237.0	Problem with SORTED BY clause
	237.3	`Mon Sep 25 1989 18:15`	SPR it	3 lines
TOPIC	585.0	RDB V3.0-B: a very long query
	585.3	`Fri Dec 08 1989 17:44`	Some observations	34 lines

Conference orarep::nomahs::rdb_31 (Rdb/VMS V3.1 - first in the 1990's)

44 posts

TOPIC	749.0	using more than 1 sorted index
	749.1	`Wed Jul 25 1990 18:48`		11 lines
TOPIC	901.0	CROSS as opposed to nested FOR's
	901.3	`Fri Aug 24 1990 12:18`	Sorts hurting performance	25 lines
TOPIC	913.0	Purging Records and Indices!
	913.3	`Tue Aug 28 1990 11:26`	Tell us more	16 lines
TOPIC	921.0	'Conjunct Conjuct' = 1/4 performance???
	921.1	`Tue Aug 28 1990 13:45`		1 lines
	921.3	`Wed Aug 29 1990 12:17`		31 lines
TOPIC	929.0	Why is OPTIMIZER not selecting INDEX ?
	929.1	`Wed Aug 29 1990 11:54`	It's the index selectivity	14 lines
	929.4	`Wed Aug 29 1990 15:24`	Lots of answers :-)	63 lines
	929.6	`Wed Aug 29 1990 16:38`	More answers :-)	19 lines
TOPIC	932.0	Optimizer again
	932.1	`Wed Aug 29 1990 15:32`	See note 929.1	9 lines
TOPIC	939.0	First n in view doesn't return row based on outer RSE
	939.1	`Thu Aug 30 1990 12:22`	Not a problem!	14 lines
TOPIC	1036.0	confused by output from rdms$debug_flags "O"
	1036.3	`Thu Sep 20 1990 13:02`	No extra optimizer work	18 lines
	1036.8	`Fri Sep 21 1990 16:12`	Will go away	15 lines
TOPIC	1053.0	When are constraints checked?
	1053.1	`Mon Sep 24 1990 13:02`		7 lines
	1053.9	`Mon Oct 01 1990 18:12`		10 lines
	1053.10	`Mon Oct 01 1990 19:33`	It's correct behavior	48 lines
TOPIC	1081.0	Different sort strategy in Rdb 3.0, 3.1, 4.0 ?
	1081.4	`Mon Oct 01 1990 17:56`	Let's see the strategy	10 lines
	1081.6	`Fri Oct 05 1990 17:55`	V4.0 strategy is the best	23 lines
TOPIC	1103.0	SQL constraint --- performance problem
	1103.3	`Tue Oct 02 1990 12:58`		25 lines
	1103.5	`Wed Oct 03 1990 12:20`		6 lines
TOPIC	1117.0	SELECT FROM VIEW GENERATES RDSBUGCHK
	1117.1	`Fri Oct 05 1990 17:11`	may be fixed in V4.0	7 lines
TOPIC	1126.0	RMU/UNLOAD problem?
	1126.10	`Tue Oct 30 1990 13:52`	Not the optimizer	20 lines
	1126.14	`Fri Nov 02 1990 14:06`	Did it work for uniform area?	12 lines
TOPIC	1255.0	optimiser index problem
	1255.8	`Fri Nov 02 1990 13:30`	Try changes, but SPR it	19 lines
TOPIC	1260.0	Index Selected by Optimizer -- I'm comfused
	1260.2	`Mon Nov 05 1990 12:47`	It's because of DESC	11 lines
TOPIC	1292.0	Trigger problem
	1292.2	`Thu Nov 08 1990 16:55`		12 lines
TOPIC	1338.0	Need help with a report
	1338.4	`Fri Nov 16 1990 12:08`	.2 query is not the one	5 lines
TOPIC	1349.0	Slow READ's when there is no data
	1349.1	`Mon Nov 19 1990 13:41`		3 lines
TOPIC	1371.0	Optimizer problem?
	1371.2	`Wed Nov 28 1990 17:48`		35 lines
	1371.4	`Mon Dec 03 1990 11:53`		14 lines
	1371.10	`Fri Jan 18 1991 11:26`	Please SPR this problem	14 lines
TOPIC	1374.0	Slow ERASE in simple DB
	1374.13	`Thu Nov 29 1990 11:30`	Integrity vs. performance	33 lines
TOPIC	1419.0	VIEWNOTRET -- V3.1B breaks V3.0B application
	1419.4	`Wed Dec 05 1990 12:22`	Group by views are R/O	11 lines
TOPIC	1424.0	Rdb problems/questions...
	1424.9	`Fri Dec 21 1990 18:22`	Some answers	45 lines
TOPIC	1431.0	RDMS$$KOD_ISCAN_GET_NEXT
	1431.3	`Thu Dec 06 1990 11:42`	Need more info	5 lines
TOPIC	1485.0	SQL SELECT STARTING WITH doesn't return records
	1485.1	`Tue Dec 18 1990 12:53`	It's fixed in V4.0	19 lines
TOPIC	1503.0	why does optimizer use this index?
	1503.1	`Thu Dec 20 1990 18:23`	It's a known problem	15 lines
	1503.3	`Fri Dec 21 1990 15:39`		11 lines
	1503.5	`Thu Dec 27 1990 12:56`		30 lines
TOPIC	1524.0	Why would ACTUAL and STORED Cardinalities differ?
	1524.4	`Mon Jan 07 1991 17:28`	It's a bug	12 lines
TOPIC	1540.0	Optimizer question
	1540.3	`Tue Jan 08 1991 12:17`	Ok, you asked it	27 lines
TOPIC	1554.0	rdbvms$triggers,questions...
	1554.4	`Wed Jan 09 1991 11:11`	Content can be modified but not recommended	7 lines
	1554.5	`Wed Jan 09 1991 11:15`		4 lines
TOPIC	1569.0	Problem with WHEN NOT EXISTS in triggers
	1569.1	`Thu Jan 10 1991 15:59`		5 lines
TOPIC	1588.0	Constraints evaluation time: verb vs commit
	1588.3	`Fri Jan 18 1991 14:32`		52 lines

Conference orarep::nomahs::rdb_41 (Rdb/VMS - Digital's Strategic Relational Database - 193.4 TPS)

17 posts

TOPIC	496.0	Multi segment index problem
	496.9	`Mon Aug 31 1992 12:36`	A possible workaround	13 lines
TOPIC	651.0	wrong index cardinality
	651.1	`Mon Aug 31 1992 17:07`	It's a bug	3 lines
TOPIC	685.0	What's quickest?
	685.11	`Fri Aug 28 1992 17:52`	A clarification	28 lines
	685.12	`Fri Aug 28 1992 18:30`	Another solution	21 lines
TOPIC	692.0	ORDER BY with Select from a view
	692.6	`Fri Aug 28 1992 18:44`		3 lines
	692.8	`Tue Sep 01 1992 12:23`	Yes, bug it is!	6 lines
TOPIC	718.0	store takes hours after constraint redefined
	718.1	`Fri Aug 28 1992 19:01`	Try it on v4.1	4 lines
	718.3	`Mon Aug 31 1992 18:19`	It is expected	30 lines
TOPIC	736.0	Delete trigger behavior
	736.2	`Tue Sep 01 1992 17:45`	I don't find this Rdb behavior	9 lines
TOPIC	740.0	Preformance problem wit V3.1B
	740.4	`Wed Sep 02 1992 15:34`	SPR? Not so fast!	16 lines
	740.6	`Fri Sep 04 1992 11:58`	"Better in v4.1" is a vague answer	17 lines
TOPIC	910.0	query optimizer 4.1b
	910.1	`Fri Sep 25 1992 16:05`	Need more info	27 lines
TOPIC	1095.0	Documentation error?
	1095.2	`Tue Oct 20 1992 15:09`	Clarification	32 lines
TOPIC	1517.0	BAD SELECT MIN() IN V4.1
	1517.5	`Mon Dec 21 1992 15:44`	SPR it right away	8 lines
TOPIC	1555.0	Poor SORTED dynamic strategy
	1555.2	`Wed Dec 30 1992 11:02`	Yep, it's non-optimal	9 lines
TOPIC	1568.0	where clause influence on execution
	1568.12	`Fri Jan 08 1993 16:52`	Heeeeeeeeere's Zia	24 lines
TOPIC	1638.0	urgent help need about optimizer's strange behaviour
	1638.1	`Fri Jan 15 1993 12:14`	May have been fixed in V4.1	6 lines

Conference orarep::nomahs::rdb_wish (Oracle Rdb Wishes and Suggestions)

13 posts

TOPIC	145.0	* More about the optimizer
	145.2	`Wed Aug 07 1991 15:04`	We do it now in Rdb V4.1	13 lines
TOPIC	212.0	*Wish for efficient MIN & MAX
	212.6	`Thu Sep 20 1990 13:44`	How about nulls in the index	18 lines
	212.11	`Thu Jul 18 1991 12:36`	Rdb has it now	3 lines
TOPIC	304.0	More index info for the optimiser
	304.1	`Tue May 14 1991 13:18`	my 2�	40 lines
	304.5	`Fri May 17 1991 15:02`		24 lines
TOPIC	642.0	Optimizer enhancement request
	642.4	`Fri Apr 15 1994 16:03`	2 other key range segments are hidden	19 lines
	642.8	`Tue Apr 19 1994 12:54`		13 lines
	642.12	`Thu Apr 28 1994 11:44`		16 lines
	642.13	`Thu Apr 28 1994 11:53`	Here's good news for you	15 lines
TOPIC	667.0	`Wed Jul 13 1994 17:59`	Allow uniqueness on subset of index columns	29 lines
TOPIC	677.0	Join order when using EXISTS
	677.1	`Wed Sep 14 1994 17:56`	Will require unnesting of subqueries	15 lines
TOPIC	678.0	More possible optimization improvements
	678.1	`Mon Sep 19 1994 12:23`	One of two	28 lines
TOPIC	705.0	Halloween prevention with DELETE WHERE CURRENT OF
	705.1	`Fri Dec 23 1994 12:15`	We should address this	19 lines

Conference orarep::nomahs::rdb_30 (VAX Rdb/VMS)

1 posts

TOPIC	1486.0	Optimizer Behaviour with Rally Sort Keys
	1486.1	`Fri Jun 23 1989 11:46`	Give more info	5 lines

Additional information

First Post:	`Fri Jun 23 1989`
Last Post:	`Mon Oct 09 1995`
# Topics:	1
# Replies:	341
# We have note bodies for:	0

Total memory used by this script: 1,528,352 (4,194,304)