Analysis Change in index - 12cr1 database
Dear Experts.
My updates are not visible since yesterday and hence raised a new thread.
continuation to link https://community.oracle.com/mosc/discussion/comment/16871600#Comment_16871600
Thanks arslan,kayk and mark.
Dear KayK,
Do you know if the statistics for your table exists before the 1st plan ?
SQL> select count(*) from ttdprod_usr.SEVA_DIP_REGISTRATIONS;
COUNT(*)
----------
1930104
SQL> select last_analyzed,num_rows from dba_tables where table_name='SEVA_DIP_REGISTRATIONS';
LAST_ANAL NUM_ROWS
--------- ----------
17-MAR-20 6511
20-MAR-22 0
SEVA_DIP_REGISTRATIONS is an online table..every month on specific dates,users will carry the registrations.After all registrations are done,this table will be archived and then truncated and then available for next month registrations. Around 20lakhs users will be registered.