From: "Joel Fradkin" <jfradkin@wazagua.com>
To: <pgsql-sql@postgresql.org>
Subject: Sorry I see my first question did not get posted (maybe because of
	the attatchments)
Date: Tue, 25 Jan 2005 22:54:22 -0500
Message-ID: <000e01c5035a$b989c140$797ba8c0@jfradkin>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

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
=A0
Wazagua, Inc.
2520 Trailmate Dr
Sarasota, Florida 34243
Tel.=A0 941-753-7111 ext 305
=A0
jfradkin@wazagua.com
www.wazagua.com
Powered by Wazagua
Providing you with the latest Web-based technology & advanced tools.
=A9 2004. WAZAGUA, Inc. All rights reserved. WAZAGUA,=A0Inc
=A0This email message is for the use of the intended recipient(s) and =
may
contain confidential and privileged information.=A0 Any unauthorized =
review,
use, disclosure or distribution is prohibited.=A0 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.
=A0

=A0