hi, we are using db2 udb v8.1 on windows, i have a sql which is
SELECT id, oeno01, oeno22, 0,'oeftol' FROM xxx.OELTOL13_OEFTOL WHERE
oeno01=2210728 AND oeno22=1 UNION ALL SELECT id, oeno01, oeno22,
1,'oeftoly' FROM xxx.OELTOL13_OEFTOLY WHERE oeno01=2210728 AND
oeno22=1 ORDER BY 2 ASC,3 ASC,4 ASC
when i run this through explain SQL, i found that total cost for
timeons is 77.43 (which pretty fast), it used index scan, but when i
run this query throught some sql tool via db2 jdbc driver (type 4 jcc
driver from fixpack 4), it takes almost 30 mins, so i don't know why
this is so much difference, i have created all the indexes DB2 design
advisor recommended. 1 1435
more info, view oeltol13_oeftoly represents a huge table with over one
million records, i create a seperated tablespace for this table and it
is DMS type, but i don't see the performance increase by doing that? da****@yahoo.com (xixi) wrote in message news:<c0**************************@posting.google. com>... hi, we are using db2 udb v8.1 on windows, i have a sql which is
SELECT id, oeno01, oeno22, 0,'oeftol' FROM xxx.OELTOL13_OEFTOL WHERE oeno01=2210728 AND oeno22=1 UNION ALL SELECT id, oeno01, oeno22, 1,'oeftoly' FROM xxx.OELTOL13_OEFTOLY WHERE oeno01=2210728 AND oeno22=1 ORDER BY 2 ASC,3 ASC,4 ASC
when i run this through explain SQL, i found that total cost for timeons is 77.43 (which pretty fast), it used index scan, but when i run this query throught some sql tool via db2 jdbc driver (type 4 jcc driver from fixpack 4), it takes almost 30 mins, so i don't know why this is so much difference, i have created all the indexes DB2 design advisor recommended. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: AHN |
last post by:
Please tell me somebody what causes the cookie set with
<%
Response.Cookies("blah") = "Blah blah"
Response.Cookies("blah").Expires = DateAdd( "h", 1, Now() )
%>
work as supposed on my local...
|
by: Dominic Godin |
last post by:
Hi,
I have an asp page that does a lot of processing and reports it's
finished by printing the word "Success". For example:
<% SomeFunction(SomeVar)
SomeFunction(SomeVar1)
...
|
by: z. f. |
last post by:
Hi,
i have asp.net vb.net wep application.
i try to investigate performance issue.
so first i built a vb.net windows application that makes http requests to my pages and show me the time taken...
|
by: Jim in Arizona |
last post by:
I'm going insane! I don't know if it's just that the .net 2.0 framework is
buggy or if it really is my code.
This is pretty hard to explain since I can't even begin to nail down why
this is...
|
by: Kevin |
last post by:
Hi,
With this, i get the error:
" Microsoft VBScript runtime error '800a01ca'
Variable uses an Automation type not supported in VBScript "
at line 79
<%
totintot=request.cookies("totintot")...
|
by: Victor |
last post by:
I have a strange problem in my website. I configured my website to run under
2 worker processes. (web garden enabled). and I stored my user information
in the current httpcontext(like...
|
by: Victor |
last post by:
Hi guys, I have a very strange problem with scriptmanager here. I want to
load a js (which is embed in the project) but everytime i try to load that,
it gives me error like
Specified argument was...
|
by: Tomasz J |
last post by:
Hello Developers,
I have a control derived from System.Web.UI.WebControls.WebControl. Control
has this property:
public string Value
{
set { _value = value; }
get { return _value; }
|
by: Prisoner at War |
last post by:
Friends, your opinions and advice, please:
I have a very simple JavaScript image-swap which works on my end but
when uploaded to my host at http://buildit.sitesell.com/sunnyside.html
does not...
|
by: sirdavethebrave |
last post by:
Hi guys -
I have written a form, and a stored procedure to update the said form.
It really is as simple as that. A user can go into the form, update some fields and hit the update button to...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| |