(unknown charset) Poor Forms query performance
From: (unknown charset) Big John <johnnyngan_at_yahoo.com>
Date: Mon, 30 Nov 1998 16:21:52 +0800
Message-ID: <73tkln$k5p1_at_news.hk.linkage.net>
Date: Mon, 30 Nov 1998 16:21:52 +0800
Message-ID: <73tkln$k5p1_at_news.hk.linkage.net>
Hi,
I have a 1 master table, and 4 detail tables
with about 40000 records each. Since I have to query from any field, either from
master or detail, or both. So I create a view that join all these tables, and
then create a form base on that view. However, It takes more than 10 minutes to
query even one record. I try tuning the SGA and rebulding the index, but still
no lucks. Can you teach me how to improve the performance? Any suggestion is
highly appericated.
I am running Oracle 8.0 on NT Server 4.0
with 128 RAM.
Received on Mon Nov 30 1998 - 09:21:52 CET