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

what is the hint?
how to use it to reduce the query processing in program?

Answer Posted / gazulas

by using hints we can direct the optimizer to follow what was specified in the hints. ex: we can direct the optimizer to do a index unique scan instead of full table scan....

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

can u give example for factless fact table

6651


Describe an informatica powercenter?

1127


What are the tasks that can be performed using sq?

1093


Briefly describe lookup transformation?

1046


Briefly define a session task?

1135


What is the difference between router and filter?

1270


Explain the code page compatibility?

1071


Explain the tuning lookup transformation - informatica

996


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

1144


What is mapping debugger?

1017


What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?

1080


How can you validate all mappings in the repository simultaneously?

1371


Write the prerequisite tasks to achieve the session partition?

1160


Different circumstance which drives informatica server to expel records?

984


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

1032