If you want to migrate a particular table from one node of HANA to another for performance or space issue :-
1. To view current location of table -
open SQL editor on HANA studio and run the sql query :-
select * from "SYS"."M_TABLE_LOCATIONS" order by LOCATION,
table_name
2. To view current location decide the node where you want to move it and run the below query on SQL editor of HANA studio:-
ALTER TABLE MOVE TO ‘node:port number’
