Query Help Performance

[james777]

I am trying to write a query to get the results
that were marked with "--+" in one sql.
The table got nearly Million rows and tried with different
sql queries but hanging and the results are not coming out.
Can anyone tell me to write an efficient query.


Col1 Col2 Col3
1 18 1011--+
1 27 1011
2 1 1011--+
2 1 1301
2 1 1201
2 2 1011
2 3 1011
5 1 1011--+
5 49 1011
6 2 1011--+
6 3 1011
6 4 1011
6 5 1011
6 16 1011
6 36 1011
7 1 1203--+
7 1 1203
7 3 1203
7 3 1203
7 4 1203
7 8 1011
8 2 1011--+
8 16 1011
8 26 1011
11 17 1011--+
12 1 1011--+
12 8 1011
12 17 1011
13 1 1011
13 3 1011
13 10 1011
13 13 1011
14 1 1011--+
14 1 1011
14 1 1011
14 1 1011
14 2 1030
14 2 1011

Thanks
NewBee 2 Oracle

 

[johnherman]

You might have better results posting this in the Oracle forum(s) rather than in Data Warehousing

-------------------------
Sometimes the grass is greener on the other side because there is more manure there !