How to give optimizer hints on DDL query ?
I have a use case to set lock_wait_timeout in an alter query. I do prefer to give it for that statement alone. Is it possible to give optimizer hint in the same statement itself?
PS : I do not prefer setting lock_wait_timeout for that entire session.