U CAN TUNE U R QUERIES BY CREATING INDEXES ON COLUMNS,AND ELIMINATING KEY

how do u tune queries?

Question Posted / chitti

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

How to elaborate tracing level?

1217

Difference between Data and Index Caches?

1194

How many input parameters can exist in an unconnected lookup?

1598

which one is better performance wise joiner or look up

1149

3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

2294

can anyone explain me about retail domain project in informatica?

7996

how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

7173

-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

5871

Describe data concatenation?

1118

Is stop and abort are same in informatica?

1039

What is the difference between writing a joiner query in ANSI style and THETA style?

2432

How can we use mapping variables in informatica? Where do we use them?

1279

How would you copy the content of one repository to another repository?

1058

what is the size ur source like(file system or database)? how many record daily come u r banking project?

2189

update strategy transformation in informatica

1120