Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Documentation for 8.*
Christian Wapenhans wrote:
> Hello,
>
> i've to optimize a sql statement for a customer. There are inner join and
> join.
>
> Is there any documentation which I can read in order to know how to do it.
>
> The statement from an mssql server doesn't work.
>
> The Problem:
>
> tab1:
> id1
> name1
>
> tab2:
> id2
> name2
>
> tab3:
> id3
> id1
> id2
>
> I need all name1s from tab1 which are empty. That means no id2 exist for
> id1.
>
> The whole problem is bigger. But this part is the problem, because there
> are 3,000,000 entry in tab2 and tab3 and 100,000 entries in tab1.
>
> The orcale version ist something like 8.0
>
>
>
> Bye from Wunstorf, Germany
> Christian
>
http://www.oracle.com/technology/documentation/index.html
That has all documentation on line, going back to 7.3.4.
May require a (free) subscription.
No pun intended, but you seem hardly the person to optimize Oracle statements, if you don't even know the basics like "how to display records from one table, that do not exist in the other?"
What is the mssql statement you used for, like V2.2?
-- Regards, Frank van BortelReceived on Sun May 22 2005 - 07:02:53 CDT