Sql

Search

oracle calculate statistics on partition

ANALYZE TABLE SCHEMA.MY_TABLE PARTITION (PARTITION_NAME) COMPUTE STATISTICS;

exec DBMS_STATS.GATHER_TABLE_STATS('MY_USER', 'MY_TABLE', ESTIMATE_PERCENT=>50, 
	GRANULARITY=>'PARTITION', PARTNAME=>'My_PARTITION_NAME', DEGREE => 8);

Comment

PREVIOUS	NEXT

Code Example
Sql :: findAllBy
Sql :: add alternate add column sql
Sql :: mysql portable
Sql :: generate series sqlserver 2005
Sql :: oracle grant create job
Sql :: first row in deluge
Sql :: python sqlalcahmey compare datetime using AND_ or OR_
Sql :: adding primery key constraint to a column
Sql :: how to get data from 2 database
Sql :: sql date time query find
Sql :: ring MySQL execute a query on the database then print the result.
Sql :: plsql regex match whole word
Sql :: HOW TO RETURN THE NUMBER OF LETTERS IN A cell in mysql
Sql :: Insert Row Providing Value Explicitly
Sql :: crear usuario oracle
Sql :: VSCode SQL Server Connection error
Sql :: create dabase psql
Sql :: how to drop mili second in sql
Sql :: sql requete number pair
Sql :: how to reset id column in sql server
Sql :: flashback in bigquery
Sql :: SQL Copy Records Matching a Condition
Sql :: mysql docker image arjun
Sql :: sql joins explained
Sql :: connect to remote mysql server
Sql :: oracle temp tablespace size
Sql :: bigquery routine
Sql :: select all users sql
Csharp :: raycast from camera to mouse unity
Csharp :: open link c#

Search

SQL

oracle calculate statistics on partition

ADD CONTENT