Hallo, i have two update statements(example): update a (4000 records / one record to update) set aid = 2 where id = 1
update b (40000 records / one record to update) set bid = 2 where id = 1 if i let them run, they will both update the data in ~30ms. now, i want to create a trigger with the second statement on the table "a", something like this: CREATE OR ALTER trigger asdf1 for a active after update position 230 as begin update b set bid = new.aid where id = new.id end i execute the statement to update table "a" and it will update both tables, but it runs ~500ms. on both tables are indices for the "id"-column. if i delete the index for table "b" the statement uses also ~500ms to run. therefor i thought, i use for the update a plan in the trigger like this: update b set bid = 2 where id = 1 plan (b index (b_id_idx1)); i can run this statement, but the trigger isnt allowing the statement to be saved. "index cannot be used in the specified plan. index b_id_idx1 cannot be used in the specified plan." (i've tested 2.5.1 and 2.5.2 RC1) maybe someone can help me, thank you
