CodeListing 1: Explain plan report on BIG TABLE query

 
Id	 Operation           Name    	 Rows  	 Bytes 	TempSpc	 Cost    (%CPU)

 0     SELECT STATEMENT                  1833K	  85M            21993    (6)
 1     SORT GROUP BY                     1833K	  85M    225M	 21993    (6)
 2     TABLE ACCESS FULL     BIG_TABLE   1833K	  85M             2417    (12)
E-mail this page
Printer View Printer View
Oracle Is The Information Company About Oracle | Oracle RSS Feeds | Careers | Contact Us | Site Maps | Legal Notices | Terms of Use | Privacy