Query optimization: Use " OR " or " IN & qu

Dúvidas, dicas e truques de SQL, Select, Update, Delete, cláusulas, operações com joins, Funções em SQLs, etc
  

Poston Wed, 05 Jul 2006 10:44 am

What is handled by the Bank faster? The use of OR or IN a select?
Know let me know?

Grateful.
marcelo9i
Location: RJ

Marcello Rodrigo

Poston Thu, 06 Jul 2006 1:21 pm

It's the same thing.
In fact, IN does not exist for the Bank. The optimizer transoforma all IN several OR.
dr_gori
Location: Portland, OR USA

Thomas F. G

Você já respondeu a dúvida de alguém hoje?
http://glufke.net/oracle/search.php?search_id=unanswered

Poston Thu, 06 Jul 2006 3:57 pm

NO, IT'S JUST A MATTER OF OPTIMIZATION, AND COMPRESSION THAT WILL MAKE THE DIFFERENCE.
DO YOU AGREE?
IF NOT, EXPLAIN TO ME WHY.
SAID.
oracle9i
Location: rio verde go

Poston Thu, 06 Jul 2006 4:27 pm

Do you have any link or document Oracle (or certified source) on this subject?

Rolled a chat with the manager who thinks OR is slower.


Grateful.
marcelo9i
Location: RJ

Marcello Rodrigo

Poston Mon, 31 Jul 2006 3:48 pm

Marcello, if you can, instead of OR try using DECODE ...
erthal
Location: Niterói - RJ


  • See also
    Replies
    Views
    Last Post


Return to SQL

Who is online

Users browsing this forum: No registered users and 3 guests