Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category

My SQL is not performing well. Describe how will you fine
tune it?

Question Posted / kingmanish


My SQL is not performing well. Describe how will you fine tune it?..

Answer / akbar

Use EXPLAIN to list out the access paths of several
different codes you come up with and choose the path that
got executed within the least time.

Is This Answer Correct ?    4 Yes 0 No

Post New Answer

More DB2 Interview Questions

why we create view.

5 Answers  

What is reorg?

0 Answers  

Can a array declared with an index be displayed(readable format) in spool?

4 Answers   Syntel, UST,

What keyword does an SQL SELECT statement use for a string search?

2 Answers  

What is the syntax for FETCH in DB2 ?

0 Answers   MCN Solutions,

What is the picture clause of the null indicator variable?

6 Answers  

how can you access index

4 Answers   IBM, Tech Mahindra,

How can you quickly find out the number of rows updated after an update statement?

1 Answers   CSI, CTS,

what are the max. & min. no. of partitions allowed in a partition tablespace?

2 Answers   IBM,

Can we declare cursor in Procudere division or open the cursor in the Working storage section. Is there any particular rules in the usage of cursors lifecycle

1 Answers   Infosys,

What is Declaration Generator(DCLGEN)?

1 Answers  

Where to download IBM DB2 Certification Dumps for the below: C2090-311 : IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1 C2090-312 : IBM DB2 11 DBA for z/OS C2090-313 : DB2 11 Application Developer for z/OS C2090-317 : DB2 11 System Administrator for z/OS C2090-541 : DB2 9.7 DBA for Linux UNIX and Windows C2090-543 : DB2 9.7 Application Development C2090-544 : DB2 9.7 Advanced DBA for LUW C2090-545 : DB2 9.7 SQL Procedure Developer C2090-546 : DB2 9.7 Database Administrator for Linux UNIX or Windows Upgrade C2090-610 : DB2 10.1 Fundamentals C2090-611 : DB2 10.1 DBA for Linux, UNIX, and Windows C2090-612 : DB2 10 DBA for z/OS C2090-614 : DB2 10.1 Advanced DBA for Linux UNIX and Windows C2090-615 : DB2 10.5 Fundamentals for LUW C2090-617 : DB2 10 System Administrator for z/OS C2090-730 : DB2 9 Family Fundamentals C2090-733 : DB2 9 Application Developer C2090-735 : DB2 9.5 SQL Procedure Developer C2090-737 : DB2 9 System Administrator for z/OS Exam

1 Answers   Mphasis,

For more DB2 Interview Questions Click Here
Categories