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

The join defined by the default data link is an outer join yes or no?

1 Answers  


What is a predefined exception available in forms 4.0?

2 Answers  


how to use buttons,check boxes in paper layout,paper design and paper parameter form in oracle report developer 10g

0 Answers  


what is oracle forms?

0 Answers  


What is the frame & repeating frame?

1 Answers  






What are different types of images?

1 Answers  


What does TKPROF stand for?

5 Answers  


difference between global n context sensitive segments?

0 Answers   Convergys,


What is the purpose of the product order option in the column property sheet?

1 Answers  


What is lexical parameter ?

2 Answers   Zensar,


in compatibility in report registration?

1 Answers   Convergys,


Can you mention lexical parameter in select statement in the data model?

1 Answers   Zensar,


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)