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 are the main issues while working with flat files as source and as targets ?

1162


What are the popular informatica products?

1013


What are the different lookup cache(s)?

1118


Did u used latest transformations of 8.6.0? for what?

1882


What is data transformation manager process?

1158


What is rank transformation in informatica

1179


difference between repository database and repository service?

1152


What is the scenario which compels informatica server to reject files?

1071


What are multi-group transformations?

1103


If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

2008


What do you understand by term role-playing dimension?

1048


What is option by which we can run all the sessions in a batch simultaneously?

1144


Tell me about Propagate functions in informatica

922


Enlist the tasks for which source qualifier transformation is used.

1040


How do you load alternate records into different tables through mapping flow?

1872