Horje
oracle gather table statistics Code Example
oracle gather table statistics 
CALL DBMS_STATS.GATHER_TABLE_STATS(
    'OWNER_NAME',
    'TABLE_NAME',
    ESTIMATE_PERCENT => 50,			-- longer but better than 1 for exec plans
    GRANULARITY => 'PARTITION',   	-- or SUBPARTITION or nothing  
    PARTNAME => 'PARTITION_NAME', 	-- or nothing
    DEGREE => 8                 	-- parallelism
);



Sql

Related
test the postgresql db connection Code Example test the postgresql db connection Code Example
sql union Code Example sql union Code Example
sql query interview questions Code Example sql query interview questions Code Example
select current_timestamp - interval '3 days'; Code Example select current_timestamp - interval '3 days'; Code Example
mysql dump with table query Code Example mysql dump with table query Code Example

Type:
 Code Example
Category:
 Coding
Sub Category:
 Code Example
Uploaded by:
 Admin
Views:
 8



 

Horje