My select statement is not working as expected, So, to overcome from such issues what are the steps needed to be taken care?
Answer Posted / nitinsharma06
1.Table is being Locked by any other resourse or not.
2.Table is reach to high water mark, REUSE STORAGE or SHRINK SPACE could resolve the issue.
3.Table or Indx(if any) stats are gather or not.
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How does a trigger work?
Why partition by is used in sql?
List out the acid properties and explain?
Is natural join and inner join same?
What are instead of triggers?
How do I remove sql plus from windows 10?
Where can I learn sql for free?
What are the subsets of sql?
what are all the common sql function? : Sql dba
What is procedure explain with example?
what is 'trigger' in sql? : Sql dba
What is partition by in sql?
Which tcp/ip port does sql server run on? How can it be changed? : Sql dba
What does trigger mean in slang?
what tools available for managing mysql server? : Sql dba