What are the Different Optimisation Techniques

1 Answer

Answer :

The Various Optimisation techniques are
a) Execute Plan :: we can see the plan of the query and change it
accordingly based on the indexes
b) Optimizer_hint ::
set_item_property('DeptBlock',OPTIMIZER_HINT,'FIRST_ROWS');
Select /*+ First_Rows */ Deptno,Dname,Loc,Rowid from dept
where (Deptno > 25)
c) Optimize_Sql ::
By setting the Optimize_Sql = No, Oracle Forms assigns a single cursor
for all SQL statements.This slow downs the processing because for
evertime the SQL must be parsed whenver they are executed.
f45run module = my_firstform userid = scott/tiger optimize_sql = No
d) Optimize_Tp ::
By setting the Optimize_Tp= No, Oracle Forms assigns seperate cursor
only for each query SELECT statement. All other SQL statements reuse
the cursor.
f45run module = my_firstform userid = scott/tiger optimize_Tp = No

Related questions

Description : What are some examples of digital marketing?  Social Media Marketing  Search Engine Marketing  Search Engine Optimisation  All of the above

Last Answer : All of the above

Description : Google Analytics, KISSMETRICS, CRAZYEGG are the examples of  Content Management Software  Website Optimisation Tools  Campaign Management Software  None of the above

Last Answer : Website Optimisation Tools

Description : Webisite optimisation is  The Process of using Controlled Experimentation  Results in improvement of Website's ability  Both the Above  None of the above

Last Answer :  Both the Above

Description : What are some examples of digital marketing?  A. Search Engine Optimisation  B. Search Engine Marketing C. Social Media Marketing  D. All of the above

Last Answer : D. All of the above

Description : What are some examples of digital marketing?  Social Media Marketing  Search Engine Marketing  Search Engine Optimisation  All of the above

Last Answer :  All of the above

Description : In the time-cost optimisation, using CPM method for network analysis, the crashing of the activities along the critical path is done starting with the activity having (A) Longest duration (B) Highest cost slope (C) Least cost slope (D) Shortest duration

Last Answer : (C) Least cost slope

Description : Linear Programming technique is a: a. Constrained optimisation technique b. Technique for economic allocation of resources c. Mathematical technique d. All of the above

Last Answer : d. All of the above

Description : In a maximisation assignment problem, the objective is to maximise ............................. a. Profit b. Cost c. Optimisation d. None of these

Last Answer : a. Profit

Description : What are the different objects that you cannot copy or reference in object groups?

Last Answer : Objects of different modules Another object groups Individual block dependent items Program units.

Description : What are the different types of segments?

Last Answer : Data segment, index segment, rollback segment and temporary segment.

Description : What are the different modes of mounting a Database with the Parallel Server ?

Last Answer : Exclusive Mode If the first instance that mounts a database does so in exclusive mode, only that Instance can mount the database. Parallel Mode If the first instance that mounts a database is started in parallel mode, other instances that are started in parallel mode can also mount the database.

Description : Suppose a customer table is having different columns like customer no, payments.What will be the query to select top three max payments?

Last Answer : SELECT customer_no, payments from customer C1 WHERE 3

Description : What are the different types of Coordinations of the Master with the Detail block?

Last Answer : POPULATE_GROUP(function) POPULATE_GROUP_WITH_QUERY(function) SET_GROUP_CHAR_CELL(procedure) SET_GROUPCELL(procedure) SET_GROUP_NUMBER_CELL(procedure)

Description : What is a join ? Explain the different types of joins ?

Last Answer : Join is a query which retrieves related columns or rows from multiple tables.Self Join - Joining the table with itself.Equi Join - Joining two tables by equating two common columns.Non-Equi Join - ... that query can also retrieve rows that do not have corresponding join value in the other table.

Description : What are different modes of parameters used in functions and procedures?

Last Answer : IN -OUT -INOUT

Description : What are different Oracle database objects?

Last Answer : TABLES -VIEWS INDEXES -SYNONYMS -SEQUENCES -TABLESPACES etc

Description : What is an UTL_FILE.What are different procedures and functions associated with it?

Last Answer : UTL_FILE is a package that adds the ability to read and write to operating system files. Procedures associated with it are FCLOSE, FCLOSE_ALL and 5 procedures to output data to a file PUT, ... , PUTF, FFLUSH.PUT, FFLUSH.PUT_LINE,FFLUSH.NEW_LINE. Functions associated with it are FOPEN, ISOPEN.

Description : What are the different types of PL/SQL program units that can be defined and stored in ORACLE database ?

Last Answer : Procedures and Functions,Packages and Database Triggers.

Description : What are the different type of a record group?

Last Answer : Query record group Static record group Non query record group

Description : What are the different types of windows?

Last Answer : Root window, secondary window.

Description : What are the different types of Package Procedure ?

Last Answer : 1. Restricted package procedure. 2. Unrestricted package procedure.

Description : What are the different types of key triggers ?

Last Answer : Function Key Key-function Key-others Key-startup

Description : What are the different methods of backing up oracle database ?

Last Answer : Logical Backups - Cold Backups - Hot Backups (Archive log)

Description : How will you swap objects into a different table space for an existing database ?

Last Answer : Export the user Perform import using the command imp system/manager file=export.dmp indexfile=newrite.sql. This will create all definitions into newfile.sql. Drop necessary objects. Run the script newfile.sql after altering the tablespaces. Import from the backup for the necessary objects.

Description : What are the different kind of export backups?

Last Answer : Full back - Complete database Incremental - Only affected tables from last incremental date/full backup date. Cumulative backup - Only affected table from the last cumulative date/full backup date.

Description : What are different types of images?

Last Answer : Boiler plate imagesImage Items

Description : Can one import/export between different versions of Oracle? (for DBA

Last Answer : Different versions of the import utility is upwards compatible. This means that one can take an export file created from an old export version, and import it using a later version of the import utility. ... database to allow the Oracle 7.3 exp/imp utilities to run against an Oracle 8 database.

Description : What are the different types of Delete details we can establish in Master-Details?

Last Answer : Cascade Isolate Non-isolate

Description : What are the different types of Delete details we can establish in Master-Details?

Last Answer : Content canvas views Stacked canvas views Horizontal toolbar vertical toolbar.

Description : What are different types of modules available in oracle form?

Last Answer : Form module - a collection of objects and code routines Menu modules - a collection of menus and menu item commands that together make up an application menu library module - a collection of user named procedures, functions and packages that can be called from other modules in the application

Description : What are the different styles of activation of ole Objects?

Last Answer : In place activationExternal activation

Description : How is link tool operation different bet. reports 2 & 2.5?

Last Answer : In Reports 2.0 the link tool has to be selected and then two fields to be linked are selected and the link is automatically created. In 2.5 the first field is selected and the link tool is then used to link the first field to the second field.

Description : What are the different default triggers created when Master Deletes Property is set to Cascade?

Last Answer : Master Deletes Property Resulting Triggers --------------------------------------------------- Cascading On-Clear-Details On-Populate-Details Pre-delete

Description : What are the different default triggers created when Master Deletes Property is set to isolated?

Last Answer : Master Deletes Property Resulting Triggers --------------------------------------------------- Isolated On-Clear-Details On-Populate-Details

Description : What are the different default triggers created when Master Deletes Property is set to Non-isolated?

Last Answer : Master Deletes Property Resulting Triggers ---------------------------------------------------- Non-Isolated(the default) On-Check-Delete-Master On-Clear-Details On-Populate-Details

Description : What are the different modals of windows?

Last Answer : Modalless windows Modal windows

Description : What are the different display styles of list items?

Last Answer : Pop_listText_listCombo box

Description : What are the different types of Record Groups?

Last Answer : Query Record Groups NonQuery Record Groups State Record Groups

Description : What are the different file extensions that are created by oracle reports?

Last Answer : Rep file and Rdf file.

Description : What are the different Parameter types?

Last Answer : Text ParametersData Parameters

Description : What are the different windows events activated at runtimes?

Last Answer : When_window_activated When_window_closed When_window_deactivated When_window_resized Within this triggers, you can examine the built in system variablesystem. event_window to determine the name of the window for which the trigger fired.

Description : What are the different Levels of Auditing ?

Last Answer : Statement Auditing, Privilege Auditing and Object Auditing.

Description : What are the different approaches used by Optimizer in choosing an execution plan ?

Last Answer : Rule-based and Cost-based.

Description : What are the different type of Segments ?

Last Answer : Data Segment, Index Segment, Rollback Segment and Temporary Segment.

Description : Can objects of the same Schema reside in different tablespaces.?

Last Answer : Yes.

Description : Can a Tablespace hold objects from different Schemes ?

Last Answer : Yes.

Description : Can a tablespace hold objects from different schemes?

Last Answer : Yes.

Description : Can objects of the same schema reside in different tablespaces?

Last Answer : Yes.

Description : What are the different plan types available in Fusion Absence Management?

Last Answer : There are three different plan types available in Fusion Absence Management, which are given below: Accrual Use this type to create absence plans that enable workers to accrue time for the ... plan to pay workers if they are not eligible for a standard maternity absence qualification plan.

Description : What are the different absence type patterns available in Fusion Absence Management?

Last Answer : An absence pattern contains a predefined set of rules that you can use as a starting point to create an absence type. The pattern that you select determines whether special fields ... patterns available in Fusion Absence Management. ∙Illness or injury ∙Childbirth or placement ∙Generic absence