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
- 4470 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 aggregate and scalar functions? : Sql dba
how does a local variable is defined using t-sql? : Transact sql
what is the different between now() and current_date()? : Sql dba
How we can update the view?
How many functions are there in sql?
What does closing a cursor do?
What is the difference between delete, truncate and drop command?
how to shutdown mysql server? : Sql dba
What can you do with pl sql?
Determine if oracle date is on a weekend?
What is the difference between subquery and correlated query?
give the syntax of grant and revoke commands? : Sql dba
Can we use distinct and group by together?
What does plv msg allows you to do?
Mention what is the function that is used to transfer a pl/sql table log to a database table?
