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
I have been trying to update my iPhone 4 and iPod touch 4 to version 5.1 but I keep receiving the error that network connection could not be established. I have tried running diagnosis and taking down my firewall. I also used all the step by step pro [More]
I'm trying to delete an album titles pictures from my photos album but can't work out how to do it. I've tried auto back up and erase which deletes other albums but not the photo album. Even selecting individual photos and selecting edit does nothing [More]
I have been sending faxes by sending doc files to print and selecting the Officejet fax as my printer option. Annoyingly, it keeps reverting to "send color" . I would like to set "sending black and white faxes" as the default.  How can [More]
1. Open up the photo gallery. 2. Pick a photo with GPS coordinates encoded. 3. Option/show on map. 4. Automatically launch Nokia Maps showing where that photo was taken. And navigate there. That was a great feature on some older E Series. But sadly n [More]
I used the devicelistx https://CCMIP/ccmadmin/reports/devicelistx.asp page in CM 4.2 for get the status on real time from devices Now I use the CM 5.1 but in this version devicelistx page doesnt exist. How can i know now the status on real time from [More]
Hi, I have a huge heap table (sql 2008) on a staging database which is used to store log history for an application. The application is not directly using this heap table. The table is having a Date column and We have a Purge Plan to remove the recor [More]
Hi all, I want to modify an existing button to set the forward url to my custom page. How can I use the setForwardURL function from OAPageContext to link to my custom page. I've been trying to trace the methods but no luck. Please Help. If there is a [More]
I just discovered an amazing way of optimizing a script, which I thought I'd share. I have a script that adds line numbers to an InDesign document (www.freelancebookdesign.com under the scripting tab). It works by adding a text frame alongside each I [More]
The "Pop Art" effect on my Photobooth is not working all of a sudden. (This is the effect where the image is split into 4 Andy Warhol- looking squares.)What I get is one picture at the top left, and the other 3/4 of the image is solid yellow. Is [More]
Can I consolidate all my iPhoto libraries? Can I store them my Time Capsule external HD?It's strongly recommended to have a minimum of 10 GB free space on the boot drive for optimal performance of both the system and applications. If you use iDVD the [More]