Ram's blog

Ram's blog

Labels

  • All About Java
  • I know something about ORACLE
  • Unix Linux The Stable Platform

SCJP 5.0 Links

  • SCP for the Java 2 Platform, SE5.0 (CX-310-055)
  • SCJP sample test paper!
  • J2SE(TM) 5.0 New Features
  • Java Programmer Certification Mock Exams
  • Java 5 SCJP questions

SCBCD 5.0 Links

  • SCBCD 5.0 Blogs
  • SCBCD 5.0 Study Guide
  • Free Mock exams and resources for SCBCD 5.0
  • EJB 3.0 Metadata Annotations Reference

SOA replaces Java EE

Blog Archive

  • ▼  2007 (12)
    • ▼  August (12)
      • what's new in servlet 2.5
      • PHP4 installation on apache2 (require root permiss...
      • How to set date in Linux OS
      • some useful unix commands
      • Oracle double byte characters sets
      • UnsupportedClassVersionError
      • UNIX command to run script as a backend process
      • Oracle Performance Issue
      • request scope attributes
      • CHMOD
      • Lotus Notes - Javamail gotcha
      • Java EE 5 Architect

About Me

Ramamoorthy
View my complete profile

Thursday, August 9, 2007

Oracle Performance Issue

Using function in the query will get the performance issue (increase the loading time)

lets take a table has got more than 1000 records

example:
SELECT * FROM EMP WHERE UPPER(NAME) = UPPER('ram') takes 15secs

whereas
SELECT * FROM EMP WHERE NAME = 'ram' takes less than a sec
Posted by Ramamoorthy at 6:15 PM
Labels: I know something about ORACLE

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)