My select statement is not working as expected, So, to overcome from such issues what are the steps needed to be taken care?
- 2 Answers
- 3934 Views
- CG, I also Faced
- E-Mail Answers
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
What are the built in functions of sql?
How many developers work on postgresql?
How can we implement rollback or commit statement in a trigger?
which tcp/ip port does sql server run on? : Sql dba
how to add a new column to an existing table in mysql? : Sql dba
How do I quit sql?
what is oracle database ? : Sql dba
Explain sql data types?
Write a sql query to convert all character to uppercase after hypen.
How to display Row Number with Records in Oracle SQL Plus?
How many sectors are in a partition?
Can we insert in view in sql?
Is left join same as join?
What are the query optimization techniques?
What is sqlservr exe?
