My select statement is not working as expected, So, to overcome from such issues what are the steps needed to be taken care?
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 |
Explain the select statement in sql?
Name some usages of database trigger?
Why select is used in sql?
What is the limitation on the block size of pl/sql?
What is constant in pl sql?
How do I delete a trigger?
What is sorting in sql?
What are the built in functions of sql?
how do you login to mysql using unix shell? : Sql dba
how to sort records in sql?
What are Nested Tables? How will u delete 5 rows from Nested Tables
Is sql a programming?
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)