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
- 4517 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 sql partition?
Why stored procedures are faster than query?
What is the maximum number of triggers, you can apply on a single table?
Explain what is sql?
Can 2 queries be executed simultaneously in a distributed database system?
Who is the owner of mysql database?
explain about mysql and its features. : Sql dba
What is the main reason behind using an index?
Write an sql query to select all records from the table?
What is primary and foreign key?
What is trigger and how to use it in sql?
How to avoid using cursors?
How do I count records in sql?
What are the parts of a basic sql query?
What trigger means?
