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
Hello, In the AR statements report, If I run the report for mutiple customers, page number has to be reset for each bill_to customer... I have the header part from the second page, so when I run the report for multiple customers...even for the new cu [More]
I monitor what my guests on my wifi network.Please look on the side of the box and give us the model number but if it is the newest Extreme.. you are pretty well out of luck. Your guests on the network can be uploading and downloading and whatever wi [More]
My computer will frequently just shut down. There is not much memory left so I'm wondering if this is the reasoning or what? It will not turn back on when this happens, unless I plug in the charger. Also, I purchased an external hard drive for backin [More]
Hi. I'm wondering if this issue is a bug or if it is somwthing wring in our environment. I'm here : "\Software Library\Overview\Operating Systems\Boot Images" and Properties on one of the boot images. I click the Drivers Tab and the list there i [More]
Hello colleagues,      I am very new to CIC and i want to know how to configure complaints in the application area of transaction CIC0 in ERP system.      It would also be great if you can provide the data base tables/ transactions which are affected [More]
I've just downloaded the trial version but haven't used it yet.  I have been watching adobe tutorials all day on Adobe Muse and so far it has everything I am looking for. I have one question, however, I am currently designing a website for a customer [More]
Hello, Quick question. How do I comment out code in the update rule?  I need to comment out a large amount of code for testing purposes. Thanks, SheilaHi Sheila Go to Update rule code (routine) ->> select the code you want to comment out with mouse [More]
My first public library ebook expires July 11 and I get this when I try to download it! HTTP 400 (Bad Request) Error The request could not be fulfilled. The cached content link request no longer exists or has expired. (Failed to retrieve cached Error [More]
No any cartificate on my nokia 2700 classic please help me my Email add. [email protected] Moderator's Note: E-mail address was removed. Please don't publish your personal contact information on a public forum.Hi, Welcome to the forum! You may visit [More]
Okay lately i've been getting an i/o error whenever trying to access my ipod 20 gig 4g through my computer, and if u listen to it closely u can hear the disk spin up then then Clunk sound and the disk is stopped, then spins up again, after that xp re [More]