Are sql tuning ways same for different DB engine？
The "tricks" are to convince the DBMS to behave the way you want it to. These are large, complex pieces of software. No two behave exactly the same. So tricks that affect one may or may not work with another.

Good practice, such as only retrieving columns that a actually needed, is applicable everywhere.