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 does the file extension accdb stand for?
What is the advantage of nosql?
How do I turn a list into a table?
what are the system privileges that are required by a schema owner (user) to create a trigger on a table?
What is rownum in sql?
What are local and global Indexes and where they are useful.
Is sql developer case sensitive?
What is use of trigger?
How do you declare a user-defined exception?
how can we destroy the cookie? : Sql dba
How do I add a primary key to a table?
Which is better trigger or stored procedure?
what's the difference between a primary key and a unique key? : Sql dba
What are actual parameters and formal parameters?
What is foreign key sql?