Define the explaining plan and its used
Define the explaining plan and how is this used?
Expert
EXPLAIN PLAN:
This command is a tool to tune SQL statements. Here to use it you should have an explain_table generated within the user you are running the explain plan intended for. It is created using the utlxplan.sql script. When the explain plan table subsists you run the explain plan command providing as its argument the SQL statement to be described. The explain_plan table is after that queried to see the execution plan of the statement. This plans can also be run by using tkprof.
Write down a short note on the difference between an ERD and EER.
Write about fossils?
Specify the options in the target session of the update strategy transformation?
Illustrates the term Open Server in Sybase?
Specify the several types of Strategies?
What do you understand by the term concurrency control in DBMS?
Illustrates the quickest sorting method to use?
Explain briefly the term an outer join?
Write down a short note on XML and also describe the uses of it?
Explain different domain which is there in BO?
18,76,764
1929562 Asked
3,689
Active Tutors
1424721
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!