Accessing a large table

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?

Thanks
Deon de Villiers Received on Mon Jul 22 1996 - 00:00:00 CEST