My select statement is not working as expected, So, to overcome from such issues what are the steps needed to be taken care?
Answers were Sorted based on User's Feedback
Answer / nitin
Possibe Scenarios
1. Check table is being locked by any other resourse.
2. Table reach to HIGH WATER MARK, resuse the storage or SHINK SPACE could overcome this problem.
3. Check the data volume.
4. Table or index(if any) is analysed or their stats are gather or not.
Is This Answer Correct ? | 2 Yes | 0 No |
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 |
What do you mean by field in sql?
Can there be more than one function with a similar name in a pl/sql block?
What are sql*plus environment variables?
What are the types of variable use in pl sql?
How to look at the current sql*plus system settings?
How do you take the union of two tables in sql?
What are the types of dbms?
What is PL/SQL table ?
what is unique key constraint? : Sql dba
what is the difference between where clause and having clause? : Sql dba
Why indexing is needed?
Can We write bulk collect statement in triggers?