Home » RDBMS Server » Performance Tuning » So much rows
So much rows [message #65716] Tue, 14 December 2004 09:25 Go to next message
Rafael
Messages: 4
Registered: February 2002
Junior Member
Hi, I have two tables that I need to join, but one have 10 milions an another 30 milions of rows. The SQL to do this is very slow. How can I minimize this problem? I already created views and put indexes in the attributes. But isn´t sufficient, oracle keep not answering...

If somebody have an idea, please answer me.
Re: So much rows [message #65719 is a reply to message #65716] Tue, 14 December 2004 21:32 Go to previous message
Frank
Messages: 7901
Registered: March 2000
Senior Member
It all depends on your query and the distribution of the data.
How many rows do you expect in the result-set ?
Are the columns on which you join distributed in a way that an index would do any good ? (< say 10-20% of data)
Do you have an otherwise restricting where-clause ?

hth
Previous Topic: Applying Hints in the query
Next Topic: Urgent:-SQL taking long time to execute
Goto Forum:
  


Current Time: Fri Mar 29 09:10:36 CDT 2024