apakah bisa di upload explain plan dari keduanya? kalo menurut saya temen anda ngeyel karena temen anda menganggap kalo composite index = 2 column di concat jadi satu.
----- Original Message ----- From: martinus j wahyudi To: [email protected] Sent: Sunday, September 06, 2009 10:33 AM Subject: [indo-oracle] [Ask] Concatenation in Where Clause Dear all friends, mau nanya, katakan ada tabel seperti ini: ID, First_Name, Last_Name, Value Kemudian saya melakukan query seperti ini: select * from table where First_Name||Last_Name = "JohnKerry"; dan select * from table where First_Name= 'John' and Last_Name = 'Kerry'; Menurut kalian, mana query yang memberikan performansi terbaik. Kalo aku liat di query analyzer, kok cost-nya mahal yg query pertama ya. tapi ada temen saya yang ngeyel klo query yang pertama lebih baik. Catt: First Name, dan Last Name sudah dibuatkan composite index (firstname, lastname) Sincerely, Martin [Non-text portions of this message have been removed] ------------------------------------------------------------------------------ No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.5.409 / Virus Database: 270.13.80/2349 - Release Date: 09/06/09 05:51:00 [Non-text portions of this message have been removed]
