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...

how do u tune queries?

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the need of an ETL tool?

1078


How many types of sessions are there in informatica.please explain them?

1157


Differentiate between sessions and batches?

1009


Explain why we use partitioning the session in informatica?

1080


What is a difference between complete, stop and abort?

1078


What are the different versions of informatica?

1257


What are the types of lookup transformation?

1066


What is workflow? What are the components of workflow manager?

1171


Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

1023


What are the designer tools for creating transformations?

1111


Under what condition selecting sorted input in aggregator may fail the session?

1115


What are the tuning techniques you applied during your last project

2018


What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?

2355


Can we override a native sql query within informatica?

1030


hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you

9815