Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 4627 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
Can we use view in stored procedure?
Can you sum a count in sql?
What is difference between joins and union?
how to include character strings in sql statements? : Sql dba
What are schema-level triggers?
How many clustered indexes can you have?
What are pl sql data types?
What is trigger types in sql?
How do I make my sql query run faster?
How do I order by ascending in sql?
What are the various levels of constraints?
What are character functions in sql?
What is union, minus and interact commands?
What are all different types of collation sensitivity?
Advantages and disadvantages of stored procedure?
