As I understand, when selecting from a table in Teradata the table is locked by default.
I would like to do a simple
select * from table without locking the table. Meaning, i want to do a select and allow other users to select from the same table without having to wait for my select to be over.
I know that i can downgrade the select lock using
LOCKING modifier as follows:
locking table my_table for access select * from my_table
But this will allow my operation not to wait for locks. To my understanding it will still lock the table and so other operations will have to wait for the lock.