IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

questions
IBM Mainframe Forums -> DB2
Post new topic   Reply to topic Quick References
View previous topic :: View next topic  
Author Message
karthi_ind

Active User


Joined: 24 Feb 2004
Posts: 131
Location: Chennai
PostPosted: Fri Aug 13, 2004 4:40 pm
 Reply with quote
hi

1) What is performance Tuning in db2?

2) Which one precedes first (Group by or Order by)?

3) Real use of Explain ?

bye
Back to top
View user's profile Send private message
RamKumar

New User


Joined: 11 Aug 2004
Posts: 3
PostPosted: Fri Aug 13, 2004 7:24 pm
 Reply with quote
Hi
Answer for 3rd question :
first group by then order by

Answer for 2nd question
Explain : It is optimizer choice of access path
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 

Similar Topics
Topic Forum Replies
No new posts Comp interview questions Mainframe Interview Questions 5
No new posts Interview Questions on Cobol DB2 program Mainframe Interview Questions 5
No new posts Mainframe Interview Questions CICS,CO... Mainframe Interview Questions 6
No new posts Viewing executing process in NDM .. q... IBM Tools 0
No new posts INCLUDE condition questions DFSORT/ICETOOL 1
Search our Forums:

Back to Top
IBMMainframes.com is not an official and/or affiliated with IBM® in anyway
Board Rules | FAQ | Downloads | Wiki | SiteMap | Contact Us