My select statement is not working as expected, So, to overcome from such issues what are the steps needed to be taken care?
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
How to start oracle sql developer?
How do you explain an index?
What does where 1/2 mean in sql?
mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql
What is t-sql? : Transact sql
when is the use of update_statistics command? : Sql dba
What are the possible values for the boolean data field?
What is int identity in sql?
What is dialect in sql?
what is the difference between sql and t-sql? : Transact sql
What is indexing in sql and its types?
What is sql used for?
How delete all data from table in sql?
How do I view a sql database?
How do you know if a relationship is 2nf?