Tim,
since some of your indexes contain quite a few duplicates, it may be
wise to add the PK to the end of these indexes. E.g. rather than
having

CREATE INDEX IDX_LOGSTOCK ON LOG(STOCK)

do

CREATE INDEX IDX_LOGSTOCK ON LOG(STOCK, ID)

Helen have answered the rest better than I will ever become capable
of,
Set