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 to Declare Fixed Length String Value In PL SQL
What is data type in sql?
What is the difference between execution of triggers and stored procedures?
What is crud diagram?
What are hotfixes and patches?
how do you login to mysql using unix shell? : Sql dba
What is the difference between rename and alias?
What is use of term?
How do I filter in sql profiler?
How do I count rows in sql query?
What are its different types of dbms?
What is difference between joins and union?
What is sql used for?
What is the purpose of primary key?
What is synchronized subquery?