Win a copy of Java Challengers this week in the Java in General forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Paul Clapham
  • Ron McLeod
  • paul wheaton
  • Devaka Cooray
Sheriffs:
  • Jeanne Boyarsky
  • Tim Cooke
  • Liutauras Vilda
Saloon Keepers:
  • Tim Moores
  • Tim Holloway
  • Stephan van Hulst
  • Carey Brown
  • Piet Souris
Bartenders:
  • salvin francis
  • Mikalai Zaikin
  • Himai Minh

How to optimize the below query to give fast results

 
Ranch Hand
Posts: 114
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi Friends,

I am not good at DB side, so i would like to take your help. Below query taking so much time to featch the results. Can anyone show me the solution about how to optimise it.

 
Ranch Hand
Posts: 182
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
What does this mean? "PUB.PUBLSEQ LIKE '%%%%%J'"
and what is the difference from this? "PUB.PUBLSEQ LIKE '%J'"

You can use only one "%" that means any and many times. You don't need to repeat it. It is not wrong but looks weird.

For optimizing your query:
1) take an explain plan for your query and focus on high costs and full table accesses.
2) using functions on where clause prevents index usage, if function usage is dispensable get rid of it.
3) adding indexes on columns used for joins may help, but it should be analyzed. Query optimization and sql tuning does not mean adding index on all join columns. A dba may help you on index analysis.

Regards,
Fatih.
 
We don't have time to be charming! Quick, read this tiny ad:
Thread Boost feature
https://coderanch.com/t/674455/Thread-Boost-feature
reply
    Bookmark Topic Watch Topic
  • New Topic