Hey,

I have some tables that i only update the table (records events)
and dont neet to read from this tables.

once in a while (around 2 hours) i need to clean thos tables (around 600000 records).

i want to run delete low_priority but it dosnt support in hql so i run it with native sql.

do i need to consider any impacts or problem that native sql can caused?

can i add constraints to the master table that in case of delete will cascade? (can it caused to problem or conflicts with hibernate ?)

Thank you

delete in sql shouldn't cause any problems. Unless ofcourse something you are going to delete is currently being used by an application in memory somewhere.