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

what is the difference between call_form, new_form and open_form?

959


what is tripstop report?

1544


how do u place it in required folder

1687


What is a user exit program in oracle reports?

759


how report can be generated if we have the database designed in oracle 10g?

1661


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

2170


How do u print the data horizantally by using XML report? EX:Suppose there is one table names as SAMPLE in that we have only two columns say empno,ename.I want the output like this,At run time user may enter 3 colums(i.e to data print horizantally). empno ename empno ename empno ename 100 aaa 101 bbb 102 ccc 103 ddd 104 eee 105 fff

1862


what is oracle forms?

863


what are bind variables?

807


difference between global n context sensitive segments?

2440


What is an oracle report? List its various types.

737


Can we invoke one form from another in a multi-forms application?

870


what are the oracle forms services components include?

762


i am having a report Jan to Dec are the columns if the present month is Mar only Mar to Dec columns should appear in report output

1769


what is a package n what r the packages availbla in report

1854