MySQL Forums
Forum List  »  IBM DB2

case statement full scan
Posted by: Ananta Pilaka
Date: June 10, 2008 12:14PM

When we use case statement in sql it makes a complete scan of the table for each row retrieved. How can we get rid of case statement or is there any other way to rewrite the query

Options: ReplyQuote


Subject
Views
Written By
Posted
case statement full scan
10817
June 10, 2008 12:14PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.