Performance Tuning Tips
Performance Tuning Tips: --> Do not select all the columns when you are fetching data from FusionDB because it will do full table scan(FTS) Instead use only required columns or Index columns. ---> Always limit the rows when fetching data. --> Use Proper Joins(Primary Key and Foreign Key relationship). --> Use Exists instead of IN. --> Use Hints.