Re: Accessing a large table
From: Fuzzy <grant_at_towersoft.com.au>
Date: 1996/07/23
Message-ID: <4t1il3$6462_at_red.interact.net.au>#1/1
Date: 1996/07/23
Message-ID: <4t1il3$6462_at_red.interact.net.au>#1/1
Deon de Villiers <tsunix_at_iafrica.com> wrote:
>Hi All
>Should Oracle handle a table of approx. 25 million rows without any
>problems? A particular SQL query when run on a subset of the large table
>of approx 100 000 rows returns a result fairly promptly (less than one
>minute), but when run on the large table the query ran for days without
>returning a result.
>Any ideas?
Have you created an index suitable for use with this query?
>Thanks
>Deon de Villiers
Received on Tue Jul 23 1996 - 00:00:00 CEST