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
What is trigger in sql?
Why do we use sql constraints? Which constraints we can use while creating database in sql?
What is schema in sql example?
What is partition by in sql?
Where is all the data on the internet stored?
Why should I use postgresql?
Which are sql * plus commands?
How to rename a column in the output of sql query?
Can we rollback truncate?
Does oracle use sql?
What is hibernate and its relation to sql?
How do I view a view in sql?
What is a constraint?
What is normalization sql?
What is the most common sql injection tool?