Welcome to Questionaries, where you can ask questions and receive answers from other members of the community.

Let us know at info@questionaries.org

Which is more faster - IN or EXISTS?

7 like 0 dislike
Hello
Which is more faster - IN or EXISTS in oracle?
please reply me. i am waiting for your reply.
Thanx
asked 1 year ago by DBA-boss (120,990 points)

1 Answer

1 like 0 dislike
 
Best answer
EXISTS is more faster than IN because EXISTS returns a Boolean value whereas IN returns a value.
answered 1 year ago by eagles11 (179,830 points)

Related questions

2 like 0 dislike
1 answer
Which of the above methods is the faster method?
asked 1 year ago by daneim (127,080 points)
2 like 0 dislike
1 answer
Which of the above methods is the faster method?
asked 1 year ago by daneim (127,080 points)
4 like 0 dislike
1 answer
Which command is used to delete all files in the current directory and all its sub-directories?
asked 1 year ago by hunter (5,930 points)
5 like 0 dislike
1 answer
What does it mean that a method or class is abstract in java?
asked 1 year ago by eagles11 (179,830 points)
6 like 0 dislike
1 answer
What does it mean that a class or member is final in java?
asked 1 year ago by DBA-boss (120,990 points)
Powered by Questionaries.org