View runs forever
From: michael ngong <mngong_at_yahoo.com>
Date: 26 Aug 2002 07:17:33 -0700
Message-ID: <ecf365d5.0208260617.436102e0_at_posting.google.com>
Date: 26 Aug 2002 07:17:33 -0700
Message-ID: <ecf365d5.0208260617.436102e0_at_posting.google.com>
Hello
I have a view with a 100k rows.The view has five columns and the
result of my query is being sorted by all the five columns.This takes
a couple of minutes in the database when I use sql.When done by three
tier it literally hangs .
This view actually gets all of certain rows from four different
tables so using indexes is out of the question
Apart from making more than one view out of this one any ideas anyone.
It is found in an Apllication so I may fortunately not take credit
for the view
If possible reply to mngong_at_yahoo.com
Thank You
Michael Tubuo Ngong
Received on Mon Aug 26 2002 - 16:17:33 CEST