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.
Explain the following term: a) OLAP b) OLTP
Illustrates the quickest sorting method to use?
Write about the Sequencers?
Illustrates the Replication Server in Sybase?
Define the Fully Functional dependency.
Explain the Aggregate Awareness?
Why there is a need to create the user object?
Illustrates the term tkprof and how is this used?
Specify the 2 modes of data movement in the Informatica Server?
Explain the term iConv and oConv?
18,76,764
1943166 Asked
3,689
Active Tutors
1456722
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!