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

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

Why oracle forms required?

1045


Explain the various types of oracle report?

1082


What is the difference between BPA AND Contract What are documents and test cases u followed

2385


what is oracle forms?

1111


i am writing a query select EmpNo from Emp how can i call in after parameter form

2128


i have a repeating frame that prints on every page for a product code. But when on page ends the info associated with that product code is truncated and not overflowed to the next page.On the next page data with the new product code is displayed. I want the data for one product code to be continued on the next page if it does not fit on a single page. The values are as: repeating frame vertical = variable horizontal = variable page protect = 0 print object on = first page base printing on = enclosing object for the outermost frame which encloses the repeating frame: print object on = last page base printing on = anchoring object end of layout section = yes rest all the values are same as the repeating frame

2998


if some data is not transfered where it will get stored

1946


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

1093


what are bind variables?

1093


List out the oracle forms configuration files?

1078


What is the difference between bind and lexical parameter?

1083


What do you understand by lov and how can it be used?

1097


List the different types of columns in oracle reports.

1005


Explain the different levels at which oracle form services interact.

1064


hi,dis is Shasi.I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out.and iwant one project with explanation please help me...

2166