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
- 3933 Views
- CG, I also Faced
- E-Mail Answers
Answer Posted / nitinsharma06
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 |
Post New Answer View All Answers
What is the difference between a database and a relational database?
What is crud diagram?
How many indexes can be created on a table in sql?
Does mysql support pl sql?
What is a trigger in sql?
Define commit, rollback and savepoint?
how many ways to get the current time? : Sql dba
What is offset and limit in sql?
what is sp_pkeys? : Transact sql
Which one is better sql or oracle?
Does sql between include endpoints?
Can pl sql procedure have a return statement?
What is the execution plan in sql?
What is the process of copying data from table a to table b?
how many groups of data types? : Sql dba
