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
- 4622 Views
- CG, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
1.Table is being Locked by any other resourse or not.
2.Table is reach to high water mark, REUSE STORAGE or SHRINK SPACE could resolve the issue.
3.Table or Indx(if any) stats are gather or not.
| Is This Answer Correct ? | 2 Yes | 0 No |
What is a schema? How is it useful in sql servers?
What is the difference among union, minus and intersect?
Why does sql need a server?
What is cross join sql?
what are the type of locks ? : Sql dba
What is the use of desc in sql?
Is microsoft sql free?
How do you know if a relationship is 2nf?
What is a common use of group by in sql?
What is the requirement of self-join?
What is a CTE (Common Table Expression), and how is it different from a subquery?
What is the difference between join and union.
27 Answers 3i Infotech, ABC, Oracle, Polaris, TCS, XT Global,
-
Oracle (3253) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
