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
- 4692 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 is your daily office routine?
how to use regular expression in pattern match conditions? : Sql dba
what is collation? : Sql dba
what is sql server agent? : Sql dba
Can we use distinct and group by together?
Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me
Is primary key clustered index?
What is the current version of sql?
how many tables will create when we create table, what are they? : Sql dba
what are all the common sql function? : Sql dba
what is bcp? When does it used? : Sql dba
Do we need to rebuild index after truncate?
Is primary key always clustered index?
If a cursor is open, how can we find in a pl/sql block?
How do I remove duplicates in two columns?
