key preserved table in a vew
I am trying to get understanding of the key-preserver tables. I have read a few articles on the subjects , but it still is somewhat vague.
We have a view SCHEMA2.V1 that is defined as follows
select a."BATCH_COMPONENT_ID",a."BATCH_ID",a."TRAN_COUNT",a."POSTED_TMS",a."POST
ED_STATUS_CODE",a."RETRY_COUNT",a."DATASET_NAME",a."NUMBER_PROCESSED",a."OUTSTAN
DING_TRANSACTIONS",a."START_NBR",a."END_NBR"
from SCHEMA1.BATCH_COMPONENT_CONTROL a,
SCHEMA0.NUMBER_PARTITION b
where a.START_NBR = b.START_NBR and a.END_NBR = b.END_NBR