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 / 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 |
Post New Answer View All Answers
Which function is used to return remainder in a division operator in sql?
What is java sql driver?
what are the t string functions available in tsql? : Transact sql
What are the different types of sql commands?
What are the different parts of a package?
How do I delete a trigger?
What is the process of debugging?
What is primary key and foreign key?
Which is the correct statement about truncate and delete?
Is left join same as inner join?
What is auto increment feature in sql?
Can unique keys be null?
how to use myisamchk to check or repair myisam tables? : Sql dba
how can we submit a form without a submit button? : Sql dba
How to create an array in pl/sql?