Basically the question was why would a view use an indexed search on one result set but a seq search on a larger result set. Same view only difference is how many rows are returned. The large result set was doing a seq search and did not return after several minutes. The same sql ran in 135 seconds on my MSSQL system.
Joel Fradkin � Wazagua, Inc. 2520 Trailmate Dr Sarasota, Florida 34243 Tel.� 941-753-7111 ext 305 � [EMAIL PROTECTED] www.wazagua.com Powered by Wazagua Providing you with the latest Web-based technology & advanced tools. � 2004. WAZAGUA, Inc. All rights reserved. WAZAGUA,�Inc �This email message is for the use of the intended recipient(s) and may contain confidential and privileged information.� Any unauthorized review, use, disclosure or distribution is prohibited.� If you are not the intended recipient, please contact the sender by reply email and delete and destroy all copies of the original message, including attachments. � � ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
