SQL Snippets ™: Tutorials for Oracle Developers

Custom Search

Home SQL Features SQL Techniques Miscellany About Blog Site Map Search

Home

SQL Features
MODEL Clause
MODEL Performance Tuning
	Session Memory
	Dimensions
	Dimension References
	Measures and Rules
	Measure Datatype
	Measure Width
	Updating Multiple Measures
	Rows
	Row Width
	Reference Models
	Partitioning
	Memory Conservation Tips
	Use Measures Instead of Rules
	Minimize Datatype Lengths
	Avoid LIKE Operator
	Update the Fewest Rows and Measures
	Setup
	Cleanup

< Previous

Read Using SQL Snippets ™ before using any of this site's sample code or techniques on your own systems.

MODEL Performance Tuning

Cleanup

Run the code on this page to drop the sample tables, procedures, etc. created in earlier parts of this section. To clear session state changes (e.g. those made by SET, COLUMN, and VARIABLE commands) exit your SQL*Plus session after running these cleanup commands.

Be sure to read Using SQL Snippets ™ before executing any of these setup steps.

drop table t_1k ;
drop table t_100k ;

exit

Setup

Linking to SQL Snippets ™

To link to this page in Oracle Technology Network Forums or OraFAQ Forums cut and paste this code.

[url=http://www.sqlsnippets.com/en/topic-12104.html]SQL Snippets: MODEL Performance Tuning - Cleanup[/url]

To link to this page in HTML documents or Blogger comments cut and paste this code.

<a href="http://www.sqlsnippets.com/en/topic-12104.html">SQL Snippets: MODEL Performance Tuning - Cleanup</a>

To link to this page in other web sites use the following values.

Link Text : SQL Snippets: MODEL Performance Tuning - Cleanup
URL (href): http://www.sqlsnippets.com/en/topic-12104.html

Ads by NSC Cards

Terms and Conditions of Use Disclaimer Privacy Policy

This page was first published on April 12, 2007.

The views expressed on this site are my own and do not necessarily reflect the views of Oracle.