Home » SQL & PL/SQL » SQL & PL/SQL » Help, optimizing query
Help, optimizing query [message #18976] Sun, 24 February 2002 17:29 Go to next message
diaz
Messages: 58
Registered: October 2001
Member
Hi, i get these from

http://download-west.oracle.com/otndoc/oracle9i/
901_doc/server.901/a87503/sql_1016.htm#26795

Avoid Transformed Columns in the WHERE Clause
Use untransformed column values. For example, use:

WHERE a.order_no = b.order_no

rather than:

WHERE TO_NUMBER (SUBSTR(a.order_no, INSTR(b.order_no, '.') - 1))
= TO_NUMBER (SUBSTR(a.order_no, INSTR(b.order_no, '.') - 1))

and unfortunately i have to this selection

...
where rtrim(a.msisdn)=rtrim(b.msisdn)

cause if i don't do that, the query will only returns record with longest length of characters..
please help me
Re: Help, optimizing query (more description) [message #18977 is a reply to message #18976] Sun, 24 February 2002 18:43 Go to previous message
diaz
Messages: 58
Registered: October 2001
Member
more addition on what i've asked before..
the data is inserted using sqlloader, i've already try to use this on the control files :
...
msisdn position (1:10) "rtrim(:msisdn)"
...

the msisdn key is 10 char length (but some of them is 9 char length), that's why i have to use rtrim..

please help me

thanks in adv.
Previous Topic: Rollup and NVL function toghether
Next Topic: Urgent
Goto Forum:
  


Current Time: Thu Mar 28 09:50:50 CDT 2024