how do u tune queries?



how do u tune queries?..

Answer / chitti

U CAN TUNE U R QUERIES BY CREATING INDEXES ON COLUMNS,AND
ELIMINATING KEY CONSTRAINTS .AND ALSO GIVE SORTING IN SQL
ITSELF.

Is This Answer Correct ?    2 Yes 4 No

Post New Answer

More Informatica Interview Questions

What is the Hierarchy of DWH?

1 Answers  


How the Informatica Server reads perameter file?

1 Answers  


difference between repository database and repository service?

0 Answers  


How many cubes create from a single model?

1 Answers  


I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

0 Answers   CTS,






What is the sequence generator transformation in informatica?

0 Answers  


Explain grouped cross tab?

1 Answers   Accenture,


wt is Dynamic lookup Transformation? when we use?how we use?

2 Answers   TCS,


Design time, run time. If you don't create parameter what will happen

0 Answers  


Enlist few areas or real-time situations where informatica is required.

0 Answers  


what is the difference between repository & Intergration service

1 Answers  


what is the mechanism of the Master-Detail joining condition?

6 Answers   IBM, Patni,


Categories