mismatch between tables and indexes
Looking for explanation for the following
If we access the table via the index we do not see nulls , If I run a full table scan there are nulls in the table . This statement implies that nulls were created without updating the indexes which point more to a system/oracle issue.
SQL> select column_name, column_position from dba_ind_columns where index_name = 'PK_F_STR_PP_UPC_FISC_WK' and index_owner = 'SSPR';
COLUMN_NAME COLUMN_POSITION
-------------------------------- ---------------
TIMEFRAME_KEY 1
PROD_KEY 2
LOC_KEY 3
MVMT_TYP_KEY 4
PRC_CAUSAL_KEY 5
SALES_CAUSAL_KEY 6
SELL_PRC_AMT 7
7 rows selected.