Re: General approach to "Top-x-items" selection?
From: GAG <gag_at_objectworks.com>
Date: 1995/08/17
Message-ID: <4108qp$7gn_at_news.fonorola.net>#1/1
Date: 1995/08/17
Message-ID: <4108qp$7gn_at_news.fonorola.net>#1/1
Be VERY Carefull with this approach. Using ROWNUM < 11 will only give the "TOP" items if you are accessing the data via an index ( thus in ordered fashion). If you are not getting indexed access ie. doing a table scan then you will get the first ten rows on the data segments' blocks ... whatever they may be ... you surely can't guarentee them to be the "TOP 10".
Regards
GAG
Gerry A. Gilchrist ( GAG ) ObjectWorks Inc. 800, 100-4th Avenue S.W. Calgary, Alberta Canada T2P 3N2 Tel: (403)237-7333 E-Mail: gag_at_objectworks.com WWW: http://www.objectworks.comReceived on Thu Aug 17 1995 - 00:00:00 CEST
***************************************************************************************