SQL Performance (MOSC)

MOSC Banner

Did the gather stats for LOB columns helps

edited Apr 9, 2015 12:46PM in SQL Performance (MOSC) 7 commentsAnswered

Hi

Did the gather stats or have the recent stats on LOB columns helps?

OWNER                          INDEX_NAME                     STA LAST_ANALYZED

------------------------------ ------------------------------ --- -------------------

FFMA                           FMA_CRG_PK                     NO  2015 02 25 03:03:38

FFMA                           FMA_CBM_SPK                    NO  2015 02 25 02:58:05

FFMA                           FMA_CBM_PK                     NO  2015 02 25 02:58:05

FFMA                           iCBG_CODE_FMA_CLIENT__1F6530B8 NO  2015 02 25 02:58:05

FFMA                           iCBS_CODE_FMA_CLIENT__1F653AB8 NO  2015 02 25 02:58:05

FFMA                           iCLT_CODE_FMA_CLIENT__FD872876 NO  2015 02 25 02:56:38

FFMA                           FMA_CBS_PK                     NO  2015 02 25 02:56:38

FFMA                           FMA_CRR_PK                     NO  2015 02 25 07:23:41

FFMA                           SYS_IL0000014214C00003$$

and if it does how should i run the gather stats? i googled it and i found it this statement

SQL> EXEC DBMS_STATS.gather_index_stats('FFMA','SYS_IL0000014214C00003$$', partname=> NULL);

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center