Hi,

I like to know what is the best practice to create index and statistics
to get better performance?

I have the following steps:
Step1:
EXEC DBMS_STATS.GATHER_TABLE_STATS('Schema_name', 'TableName',
estimate_percent => .1)

Step 2:
CREATE INDEX SchemaName.TableName_Inx1 ON SchemaName.TableName
(column1, column2) TABLESPACE TableSpaceName PARALLEL 4 COMPUTE
STATISTICS

I appreciate your advise.

Thanks
Saleh

------------------------------------------------------------------------------
This e-mail transmission may contain information that is proprietary, privileged and/or confidential and is intended exclusively for the person(s) to whom it is addressed. Any use, copying, retention or disclosure by any person other than the intended recipient or the intended recipient's designees is strictly prohibited. If you are not the intended recipient or their designee, please notify the sender immediately by return e-mail and delete all copies. OppenheimerFunds may, at its sole discretion, monitor, review, retain and/or disclose the content of all email communications.
==============================================================================

Oracle LazyDBA home page