I found out that the renaming of large tables (more than 1000000 entries) takes some time.
I need to rename one table so I can give its name to the other (I want to keep both tables)
Code:
ALTER TABLE t1  RENAME TO  t3;
ALTER TABLE t2  RENAME TO  t1;
Is there any better and more time-efficent way to do this?
Thanks