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
- 4402 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 a subquery in sql?
Is sql developer case sensitive?
What is compilation error in pl sql?
how to do backup entire database? : Transact sql
What is primary key and unique key?
What are the types pl/sql code blocks?
Is the primary key an index?
What is the difference between inner join and outer join?
Which is better varchar or nvarchar?
Do stored procedures prevent sql injection?
What is a recursive stored procedure?
What is user in sql?
What is mutating error?
What is ttitle and btitle?
What is the use of %rowtype?
