Thank-you,
I read the article, but my goal is to delete a huge table so for that I create a temp, intermediate table.
After that I use a cursor which read rows from the temp table and I make a delete.
But the error is at the time of the creation of temp table.
So if I can not use or create a...
Hello,
Will some one help me?
Which of the two requests, which return the same result, is more quickly ?
More generally is than the fact of making a connection between two tables is more powerful than to call upon overlapping SELECT?
Request 1
CREATE TABLE MY_TEMP_TRANS
NOLOGGING
PARALLEL...
Bonjour,
Est-ce que quelqu'un pourra m’aider ? Laquelle des deux requêtes, qui retournent le même résultat, est plus performante ?
Plus généralement est ce que le fait de faire une liaison entre deux tables est plus performant que de faire appel à des SELECT imbriqués ?
Requête 1 :
CREATE...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.