Sitemap

Amicuk Programming Answers

Performance issue doing a prepare statement with LIKE

-0001-11-30   Views:0

Advertisement

Hi I'm doing a preparestatement like this select foo from bar where des like ? and then do the prepare with the string 'foo%' If I do the prepare of this variable, the query is very slow. If I don't do the prepare, the query is very fast. Can anyone

Hi
I'm doing a preparestatement like this
select foo
from bar
where des like ?
and then do the prepare with the string 'foo%'
If I do the prepare of this variable, the query is very slow. If I don't do the prepare, the query is very fast. Can anyone help me out on this? DBA's will kill me if I don't use prepare statements but users will kill be if the query is slow...
Thank you!
HappyGuy

The replay answer
Advertisement
As indicated in the last reply this probably has to do with use of string literals over bound variables
With a prepared statement the optimiser dosen't get the chance to use histograms against your data... so whilst it might be more efficent to drive off an index for some of the searches it looses access to the data (histograms) that enable it to make this decission...
Hints are probably the way to go... if your sure that driving off a index is always going to be the most efficent...
Using explain (inside of JDeveloper9i or turning on the autotrace functionality inside of sqlplus) will give you some idea of how Oracle would drive the query if you use a string literal
Dom

Go to See the other 3 answers

Performance issue doing a prepare statement with LIKE

Category:DefaultRelease time:-0001-11-30Views:130

Hi I'm doing a preparestatement like this select foo from bar where des like ? and then do the prepare with the string 'foo%' If I do the prepare of this variable, the query is very slow. If I don't do the prepare, the query is very fast. Can anyone[More]

RE: Case 59063: performance issues w/ C TLIB and Forte3M

Category:DefaultRelease time:2015-10-11Views:130

Hi James, Could you give me a call, I am at my desk. I had meetings all day and couldn't respond to your calls earlier. -----Original Message----- From: James Min [mailto:jminbrio.forte.com] Sent: Thursday, March 30, 2000 2:50 PM To: Sharma, Sandeep;[More]

Performance issues with Exits

Category:DefaultRelease time:2015-10-11Views:130

Hi, Has anyone had any issues with performance when updating the planning buffer using the Exit FM? What are the things to prepare for about performance issues in production system? Please recommend. Thanks RTHi Rob In the case of performances proble[More]

Windows 7 Enterprise login performance issue RODC site

Category:DefaultRelease time:-0001-11-30Views:130

Hi,  We are deploying windows 7 enterprise to all our computers in our domain and we didn't have any performance issue on any site with Full DC. Now we are facing a problem with our multiple sites with RODC but only with new deployed windows 7 (WinXp[More]

Required info on SQL Server Performance Issue Analysis and Troubleshoot way

Category:DefaultRelease time:-0001-11-30Views:130

Dear All, I am going to prepare the simple documentation steps on SQL Server Performance Issue Analysis and troubleshoot method. I am struggling to make this documentation since we have different checklist (like network latency,disk latency, memory/p[More]

Report Performance Issue - Activity

Category:DefaultRelease time:2015-10-11Views:130

Hi gurus, I'm developing an Activity report using Transactional database (Online real time object). the purpose of the report is to list down all contacts related activities and activities NOT related to Contact by activity owner (user id). In order[More]

Report performance Issue in BI Answers

Category:DefaultRelease time:2015-10-11Views:130

Hi All, We have a performance issues with reports. Report is running more than 10 mins. we took query from the session log and ran it in database, at that time it took not more than 2 mins. We have verified proper indexes on the where clause columns.[More]

BW BCS cube(0bcs_vc10 ) Report huge performance issue

Category:DefaultRelease time:2015-10-11Views:130

Hi Masters, I am working out for a solution for BW report developed in 0bcs_vc10 virtual cube. Some of the querys is taking more 15 to 20 minutes to execute the report. This is huge performance issue. We are using BW 3.5, and report devloped in bex a[More]

Interested by performance issue ?  Read this !  If you can explain, you're a master Jedi !

Category:DefaultRelease time:2015-10-11Views:130

This is the question we will try to answer... What si the bottle neck (hardware) of Adobe Premiere Pro CS6 I used PPBM5 as a benchmark testing template. All the data and log as been collected using performance counter First of all, describe my comput[More]

Performance Issue for BI system

Category:DefaultRelease time:2015-10-11Views:130

Hello, We are facing performance issues for BI System. Its a preproductive system and its performance is degrading badly everyday. I was checking system came to know program buffer hit ratio is increaasing everyday due to high Swaps. So asked to chan[More]

Is there a recommended limit on the number of custom sections and the cells per table so that there are no performance issues with the UI?

Category:DefaultRelease time:2015-10-11Views:130

Is there a recommended limit on the number of custom sections and the cells per table so that there are no performance issues with the UI?Thanks Kelly, The answers would be the following: 1200 cells per custom section (NEW COUNT), and up to 30 custom[More]

Hot
My brother just got an iPod, and he keeps using my downloads so I can't put them on a second device. Is there a way to make it so you have to log in to start doing anything with iTunes?I'd suggest you give your brother his own Windows user account, t [More]
Hi all, I have activated batch management for Material A, When i do MIGO system is asking for Batch i am also entering some Batch say 1023 But i have not gone to MSC1N where we create Batch for particular material. without creating there, i directly [More]
I used to be able to open up iclouds on my ipad, now it is a light grey and am unable to.  At the same time my contacts are missing and i can't open up accounts which is in settings - mail - accounts? I have the 'new ipad 3'.If you have restrictions [More]
Installed itunes for 64 bit windows 7 as instructed. Installation successful, but upon opening itunes, I get this message: Problem signature:   Problem Event Name:    BEX   Application Name:    iTunes.exe   Application Version:    10.3.1.55   Applica [More]
When using the contextual menu to send files directly, to a known and pre-selected Bluetooth device, the 'scan for device' windows ALWAYS appears. In my case it's usually to send to a smartphone which is established in system preferences and as such, [More]
Greetings, While doing a message mapping I need to get the value from R3 system using an RFC, is it is possible ?Hi we can do by using rfc look ups Lookup in mapping is the feature provided by SAP to lookup the data in the target R/3 or DB systems wi [More]
I have an iPod Classic and want to connect to my car stereo using the auxiliary jack. The problem is with the iPod to max and the car stereo to max, I just about have a decent volume for sitting in the parking lot with the engine off. I went to the d [More]
Hi, I tried to shutdown immediate the server. This is hanging. Can someone help? thxhi the dbf file is removed by accident. But now I am still waiting for the shutdown immediate... The alert log: Thu Aug 2 20:20:19 2007 ORA-1013 signalled during: ALT [More]
Hi I trying to find the log file that is generated using RMAN invoked from EM. I can only see the file using Internet Explorer with the URL: em/console/database/rec/bkpMgmt?skey=257&type=oracle_database&target=isatprod.dla_dns.com&event=showJo [More]
how i can update s/w 4 E63 ans i want update os what i do .http://www.nokia.co.in/support/product_support/e63_support --------------------------------------------------​--------------------------------------------------​------------------------------ [More]