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 to load query faster,so that It will take less time to load?

Answer Posted / karthik

You can increase the loading of query faster in following ways:

Query Optimization (Reducing the complexity in query).
Buffer cache increasing
Using Tier 0 (Flash storage) to increase IOPS.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is an expression transformation in informatica?

1033


What is transformation?

1097


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

1121


What differs when we choose the sorted input for aggregator transformation?

1015


What all join we can perform in LOOKUP transformation?

966


Mention few power centre client applications with their basic purpose?

943


tell me 5 session failure in real time how can you solve that in your project?

2290


Which development components of informatica have the highest usage?

1033


Mention few advantages of router transformation over filter transformation.

1021


How to update or delete the rows in a target, which do not have key fields?

1173


What are the basic requirements to join two sources in a source qualifier transformation using default join?

1121


What is decode in informatica?

1148


What are the differences between source qualifier and joiner transformation?

1055


what are the deliverables?in your project?

2150


generate date / time dimension in informatica

1124