Oracle : Updating statistics for a table or schema via Rocket99 : Database Administration and SQL Programming Plus More

Custom Search

www.rocket99.com : Technical Guides

Sybase

Oracle

UNIX

Javascript

Technical Guides

Sybase

Oracle

UNIX

Javascript

Of Interest

Be responsible for your future
Enter the USA legally!

Visa, Green Card, Citizenship, Passport
Consultation Services

Oracle » Administration » DBA »

Updating statistics for a table or schema

EXEC DBMS_STATS.GATHER_TABLE_STATS('SCHEMA1','COMPANY'); EXEC DBMS_STATS.GATHER_SCHEMA_STATS('SCHEMA1'); <OR> ANALYZE TABLE COMPANY COMPUTE STATISTICS ;

Oracle : Related Topics

Oracle : Administration : Server Manager
Oracle : Administration : O/S Password Authentication
Oracle : Administration : Database Creation
Oracle : Administration : Tablespace Creation
Oracle : Administration : Increasing the size of a tablespace
Oracle : Administration : Rollback segments
Oracle : Administration : Adding a redo log file set
Oracle : Administration : Altering table storage
Oracle : Administration : Backing up data files
Oracle : Administration : Taking tablespaces offline
Oracle : Administration : Creating users
Oracle : Administration : DB Verify
Oracle : Administration : Clearing Log Files
Oracle : Administration : Moving Data Files
Oracle : Administration : Index Management
Oracle : Administration : Creating a Schema
Oracle : Administration : Enabling Archive Logging
Oracle : Administration : Killing Sessions
Oracle : Administration : Recovering an Instance
Oracle : Administration : Drop a table and deallocate space
Oracle : Administration : Dropping a Tablespace
Oracle : Administration : Restricted Mode
Oracle : Administration : Oracle Issues, Facts You Should Know

Sybase Web Site
Sybase iAnywhere Mobile Web Site
Oracle Enterprise Web Site

Get the latest Rocket99 news and tech tips via

About this Guide to Sybase, Oracle, and UNIX

Advertise on this site

Copyright © 2019 Stoltenbar Inc All Rights Reserved.