IN vs OR of Oracle, which faster?

by

IN is preferable to OR — OR is a notoriously bad performer, and can cause other issues that would require using parenthesis in complex queries.

Better option than either IN or OR, is to join to a table containing the values you want (or don’t want). This table for comparison can be derived, temporary, or already existing in your schema.

More Related Contents:

  1. Inner join vs Where
  2. Difference between Oracle’s plus (+) notation and ansi JOIN notation?
  3. How do you interpret a query’s explain plan?
  4. Oracle , != , ^= operators
  5. Receive an unexpected symbol error in my PLSQL query [closed]
  6. SQL Query to concatenate column values from multiple rows in Oracle
  7. Select First Row of Every Group in sql [duplicate]
  8. Oracle: how to UPSERT (update or insert into a table?)
  9. Get top results for each group (in Oracle)
  10. Comparing Dates in Oracle SQL
  11. Oracle Differences between NVL and Coalesce
  12. Oracle SQL query: Retrieve latest values per group based on time [duplicate]
  13. MySQL INSERT INTO table VALUES.. vs INSERT INTO table SET
  14. SQL – How to store and navigate hierarchies?
  15. GROUP BY / aggregate function confusion in SQL
  16. Oracle “(+)” Operator
  17. How do you create a temporary table in an Oracle database?
  18. What exactly do quotation marks around the table name do?
  19. How can I get column names from a table in Oracle?
  20. What’s the difference between RANK() and DENSE_RANK() functions in oracle?
  21. How to check the maximum number of allowed connections to an Oracle database?
  22. Select without a FROM clause in Oracle
  23. Is there any way to flush output from PL/SQL in Oracle?
  24. PLSQL Insert into with subquery and returning clause
  25. SELECT from table with Varying IN list in WHERE clause
  26. Does Oracle use short-circuit evaluation?
  27. Advice Using Pivot Table in Oracle
  28. ORACLE SQL:Get all integers between two numbers
  29. Oracle- Split string comma delimited (string contains spaces and consecutive commas)
  30. Local Temporary table in Oracle 10 (for the scope of Stored Procedure)

Leave a Comment