Path: utzoo!utgpu!jarvis.csri.toronto.edu!mailrus!shadooby!samsung!cs.utexas.edu!usc!apple!voder!pyramid!unify!nico From: nico@unify.uucp (Nico Nierenberg) Newsgroups: comp.databases Subject: Re: RDBMS sux Message-ID: <2572FC1D.23671@unify.uucp> Date: 28 Nov 89 21:43:56 GMT References: <860@anasaz.UUCP> <881@anasaz.UUCP> <17393@netnews.upenn.edu> Reply-To: nico@unify.UUCP (Nico Nierenberg) Organization: Unify Corporation, Sacramento, CA, USA Lines: 21 In article <17393@netnews.upenn.edu> catone@dsl.cis.upenn.edu (Tony Catone) writes: >In article <881@anasaz.UUCP> john@anasaz.UUCP (John Moore) writes: >>You tell me! Here is the application: I have a reservation system with >>500,000 names in it. Someone wants to display a list of similar >>names (where similar can be resolved to >= "xxx"). They only have >>room on their screen for 20 names. How can I only get 20 names? > >I believe Oracle's SQL-Forms module allows you to specify this automatically. >Give them a call and ask for the SQL-Forms demo disk; it will show you what >you need to know. Be forewarned, however, that Oracle sales people can be >a bit much to deal with sometimes, so you really want to ask for the product >literature and demo disk and then decide for yourself. Accell from Unify can do this using the browse feature, and if you set up your indexes correclty it will only look at the rows which are actually displayed. The user can then decide to browse through additional rows. Best of all it will do it on any one of several data bases. Nicolas Nierenberg Unify Corp. Brought to you by Super Global Mega Corp .com