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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

difference between global n context sensitive segments?

2208


a text item is there what r the different types of triggers associated with it

1514


How can we generate report output in excel format?

555


How to create Drill down report?

1696


what is difference between group above and group left report

3204






suppose u have been seven tables based on that u have to create a report u don't have access to db. then how do u find the relation between tables

1598


Explain the various types of oracle report?

549


hiding item in report how like that properly,thats manually but at runtime i want to do

2555


Name the different triggers supported by oracle reports and their firing order.

589


What do you understand by oracle forms?

587


In what sequence do triggers get fired by oracle forms?

539


can you convert or reverse engineer a fmx back to a fmb file?

708


How can we expand Parameter Form Canvas on Reports 6i?

1959


In oracle forms report, what is the maximum length of record group column? What are the different types of record groups?

814


Why oracle forms required?

565