Performance tuning should be done first, not last. Well performing queries are generally more efficient in memory usage.
Database being entirely in memory doesn't automatically mean the queries will be fast.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability