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>


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

Original text of this message