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
New to Mac (part II). Ok, new to Mac part II means I tried a couple years ago but because I was dependent on MS products and IE (have to have IE for real estate) I had to switch back to PC. Now with new Intel chip and am happy to say I am the proud n [More]
I have a officejet 6700 and i use a mac lap yop. All of a sudden I cant print to it. Not sure why or what to do about it. Hope someone can helpWhat version of OS X? How is the printer conneced?  If wireless, what router? Say thanks by clicking "Kudos [More]
Dear Sir, How can we know the list of all codes created in material master according to there category like MRM ERM etc... If any one know good way pls answer soon Thanks & Regard Ajay PareekHi Ajay, If u are looking for Material list based on "M [More]
Hi all Can anybody help me with a piece of code for deleting all files (including dirctory) in a directory... Thanks Deepa Khave a look at this http://javaalmanac.com/egs/java.io/DeleteDir.html?l=relRead other 3 answers [More]
I've created an image for computers at my school. When I go into System Preferences>Accounts, and authenticate, I am unable to access the Login Items tab. The tab isn't grayed out or anything. It's just that when I click on it, nothing happens. It st [More]
I have a new MacBook Pro 10.6.8 I downloaded the latest upgrade for Reader (10.1) and it won't allow me to open any pdf files without accepting the "User License Agreement." When I click "Agree" I get an error message a mile long and c [More]
Hi I am a part of a team on Adobe CC subscription. Wanted to download and install the apps on my home PC as well. Logged in, Downloaded and installed the Adobe CC Desktop app. Then installed  Photoshop. It gave me  a 30 day trial. Is that what you ge [More]
I have a Windows 7 Ultimate computer I'm trying to access through Remote Desktop. I'm able to access that computer from another computer when both are in the same LAN, but I fail to access it through the internet. I already tried disabling windows fi [More]
Seems that the install page on the Adobe site is only configured to install the package on the system accessing the download page on the Adobe site. I need access to the installer file so that I can update the version of Shockwave Player that is inst [More]
Hi I have table called CS_LM_CUST.Every day I am getting 1,50,00 records every day.And all the records I am inserting.And every two months data I am doing purging.My requirement is to load chaged data between 2 days i.e current day feed minus previou [More]