My understanding is that in ARS 7.5, an extra "top xxx" is added to the SQL statement in sql server databases and a extra " .... AND ROWNUM < xxxx " is added to Oracle ones. I can't remember what is the syntax for DB2
So for instance in Oracle SELECT C1.T500, C2.T500 FROM T500 where C2 = 'Demo' would become SELECT C1.T500, C2.T500 FROM T500 where C2 = 'Demo' AND ROWNUM < 10000 Guillaume ________________________________ From: Action Request System discussion list(ARSList) [[email protected]] on behalf of Kali Obsum [[email protected]] Sent: Thursday, April 22, 2010 6:16 AM To: [email protected] Subject: Search Results Returned Limit ** In the Remedy User Tool, there is an option to limit the number of search results to be returned. How does this work in the DB level? Does it mean that if the query performed produces 10,000 results, the DB will still search for those 10,000 but only a limited number will get displayed in the User Tool? Or will the limit already be incorporated in the query such that only the top N results will be queried? Regards, Kali NOTICE The information contained in this email is confidential. If you are not the intended recipient, you must not disclose or use the information in this email in any way. If you received it in error, please tell us immediately by return email and delete the document. We do not guarantee the integrity of any e-mails or attached files and are not responsible for any changes made to them by any other person. _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"

