OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » performance

Mon, 29 April 2002 03:07

aruna
Messages: 33
Registered: January 2002

Member

i need to know in sql...whether IN or EXIST command is
efficient..?

Mon, 29 April 2002 05:15

Amit
Messages: 166
Registered: February 1999

Senior Member

I think 'Exist' command is more efficient than 'IN'
b'coz in 'IN' case qry checks each record and it will take some time to give output

Previous Topic:	Trigger won't update timestamp??!
Next Topic:	Urgent Urgent ....

Goto Forum:

]

Current Time: Fri Apr 26 03:15:03 CDT 2024