Why is a Where clause faster than a group filter or a format
trigger?



Why is a Where clause faster than a group filter or a format trigger?..

Answer / anil_abbireddy

Where clause filter's the data at the time of data fetching
or selecting from the database where as grop or format
trigger will work on the result set of fetched data

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Oracle Forms Reports Interview Questions

Can any one send me oracle form and reports tutorials from which i may get help.contact me on my mail cse_kashif@hotmail.com.

0 Answers  


How to create Drill down report?

0 Answers   ABB, ESS, Infosys,


What do we mean by record group in oracle forms?

0 Answers  


What are the trigger associated with image items?

3 Answers  


What are the different window events activated at runtimes?

1 Answers  






what is an object groups?

2 Answers  


Have you come across the error ?Failed while printing ?. Why it is happened and How to solve that?

0 Answers   Convergys,


Oracle me hindi notes chahiye or any web site address plz Give me in my email add,/////////// sunny.145@rediff.Com

2 Answers  


For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame?

1 Answers  


Which of the above methods is the faster method?

1 Answers  


How does the command POST differs from COMMIT ?

2 Answers  


What is an Alert ?

2 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1789)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)