Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Performance with index order usage

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
Vallabhaneni

New User


Joined: 30 Sep 2006
Posts: 4

PostPosted: Thu Mar 05, 2009 2:33 am    Post subject: Performance with index order usage
Reply with quote

Hello,

I need help ond DB2 performance.

I have table T1 index is IX on columns C1, C2, C3, C4 .

right now the sql in the program is

Select * from T1
Where C1 = 1
and C3 = 3
and C4 = 4
and C2 = 2

program is using the index columns in the where clause,

but the index order is C1,C2, C3, C4 but the where cluase is using
C1,C3,C4,C2

Is that matter to performance?.

Please clrify

Thank you
Back to top
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Thu Mar 05, 2009 2:38 am    Post subject:
Reply with quote

Hello,

Quote:
Is that matter to performance?.
It should not matter. The optimizer should recognize this.

You might talk with your dba and run an "explain" for confirmation.
Back to top
View user's profile Send private message
ashimer

Active Member


Joined: 13 Feb 2004
Posts: 551
Location: Bangalore

PostPosted: Thu Mar 05, 2009 4:03 pm    Post subject:
Reply with quote

it doesnt affect performance ....
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts SQL - select data available in index Nileshkul DB2 3 Mon Jun 26, 2017 1:30 am
No new posts )SEL and )ENDSEL usage cvnlynn TSO/ISPF 4 Thu Jun 15, 2017 1:15 am
No new posts CONTIG for performance? JPVRoff JCL & VSAM 7 Fri Jun 09, 2017 8:39 am
No new posts Need inputs on Space requirement and... ashek15 IMS DB/DC 0 Sat Apr 01, 2017 8:26 am
No new posts setting new limit Key values for inde... srilata83 DB2 1 Fri Feb 10, 2017 9:24 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us