Collection and sharing of, interview questions and answers asked in various interviews, faqs and articles.....
Oracle : How would you go about generating an EXPLAIN plan?
Create a plan table with utlxplan.sql. Use the explain plan set statement_id = 'tst1' into plan_table for a SQL statement Look at the explain plan with utlxplp.sql or utlxpls.sql
No comments:
Post a Comment