1.

Reasons Of Poor Performance Of Query?

Answer»
  • No indexes
  • EXCESS recompilations of stored procedures.
  • Procedures and triggers without SET NOCOUNT ON.
  • Poorly written query with unnecessarily complicated JOINS
  • HIGHLY normalized database design.
  • Excess USAGE of cursors and TEMPORARY tables.


Discussion

No Comment Found

Related InterviewSolutions