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

Conference iosg::all-in-1_v30

Title:	OLD ALL-IN-1 (tm) Support Conference
Notice:	Closed - See Note 4331.l to move to IOSG::ALL-IN-1
Moderator:	IOSG::PYE

Created:	Thu Jan 30 1992
Last Modified:	Tue Jan 23 1996
Last Successful Update:	Fri Jun 06 1997
Number of topics:	4343
Total number of notes:	18308

157.0. "Indexed or Sequential Searches" by KERNEL::COOPER (Suzanne Cooper UK Customer Support (833)3502) Tue Mar 03 1992 10:00

Hello,

	I can't seem to find in any of the previous notes files what I am 
looking for.  
	As always, I have a customer who wants to have a definitive answer, 
on Indexed or Sequential Searches.  The Manual (ref Application Programming 
Guide page 4-14) on Optimizing the Performance of an RSE states that Using 
EQS, ENS or BEGINNING will do a indexed search.
	The Notes at the bottom of the page then state that that only a EQS 
or BEGINNING when searching the key will do an indexed search.

It (EQS ENS and BEGINNING) or (EQS and BEGINNING) that perform a Indexed 
search.

Are there any exceptions to the information in the manual.

Suzanne

T.R	Title	User	Personal Name	Date	Lines
157.1	See V3.0 doc set.	KAOFS::M_MORIN	Le diable est aux vaches!	`Tue Mar 03 1992 13:47`	7
	If you look at the V3.0 guide, they have removed the note at the bottom of the page 4-14. That page has now become page 16-11. Hope that helps. Mario
157.2	EQS and BEGINNING .... sometimes	IOSG::ECHRISTIE	Eileen Christie	`Tue Mar 03 1992 13:53`	6
	As far as I know EQS and BEGINNING are the only ways of getting an indexed search. However, even this is not guaranteed if you use complex OR conditions (AND is OK) or if you dont supply a valid/correct key of reference -eileen
157.3		KERNEL::COOPER	Suzanne Cooper UK Customer Support (833)3502	`Tue Mar 03 1992 15:00`	3
	Thanks for the info. Suzanne
157.4	Not quite so simple	SCOTTC::MARSHALL	Pearl-white, but slightly shop-soiled	`Tue Mar 03 1992 17:35`	9
	Hi, It's not quite as simple as that (what you specify in the RSE). Some "special" datasets (ie those that don't simply map RMS files) will never do indexed searches, and it's possible (although I can't think of an example) that can only do indexed (ie specific key value) "searches", regardless of what you put in the RSE. Just something of which to be aware... Scott
157.5		IOSG::WDAVIES	Vic Williams is still not free	`Thu Mar 05 1992 18:36`	1
	For example... looking for Private Distribution lists. :-)