| So much rows [message #65716] |
Tue, 14 December 2004 09:25  |
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  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
