#Optimization

How do you optimize an Angular application? Please mention techniques such as Lazy Loading, OnPush Change Detection, trackBy, and Caching.

Consider the following React component using useMemo. Why might useMemo not behave as expected in this example? Explain how useMemo works, what dependency arrays do, and when useMemo should or should not be used.

Optimize your solution and explain the time and space complexity.

Describe performance optimization techniques and error handling strategies applied in your projects.

Briefly explain various SQL query optimization techniques, including indexing, avoiding SELECT *, using EXPLAIN, denormalization, and slow query analysis.