Oracle stuff

Some useful Oracle commands:

Statistics

ANALYZE TABLE emp COMPUTE STATISTICS FOR ALL INDEXED COLUMNS;

see: http://www.oreilly.com/catalog/orsqltunpr/chapter/excerpt.html; http://www.oracle.com/technology/pub/articles/lewis_cbo.html

Settings


desc user_constraints;

Leave a Reply

 

 

 

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

*