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
Define SQL and state the differences between SQL and other conventional programming Languages?
What does the file extension accdb stand for?
discuss about myisam key cache. : Sql dba
Are dml statements autocommit?
What are the benefits of pl sql?
Can ddl statements be used in pl/sql?
What is clustered index sql?
Is join an inner join?
What happens when a trigger is associated to a view?
what is uncommittable transactions? : Transact sql
Write the alter statement to enable all the triggers on the t.students table.
what is the difference between char and varchar data types? : Sql dba
how to use like conditions? : Sql dba
What is scalar function?
what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?