Quote Originally Posted by iris View Post
See the application is under development stage, as a DBA how to check or analyze the tables and views are designed considering Database performance.


Like for example, Are developers are creating proper indexes method? etc


thanks,
Some things will be obvious in development (like missing indexes), but other wise you may need to execute the query in production and examine the execution plan.