Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

My select statement is not working as expected, So, to overcome from such issues what are the steps needed to be taken care?

Question Posted / dev

Answers were Sorted based on User's Feedback



My select statement is not working as expected, So, to overcome from such issues what are the steps ..

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

My select statement is not working as expected, So, to overcome from such issues what are the steps ..

Answer / 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

More SQL PLSQL Interview Questions

How to use sql*plus built-in timers?

0 Answers  

What do you mean by rowid?

0 Answers  

What is %type in pl sql?

0 Answers  

How do you break a loop in pl sql?

0 Answers  

What is cartesian join in sql?

0 Answers  

What is a delimiter in sas?

0 Answers  

what is blob? : Sql dba

0 Answers  

What are the Diff B/W Cursor and REF Cursor

3 Answers   CTS,

How do I find sql profiler?

0 Answers  

Advantages and disadvantages of stored procedure?

0 Answers  

What do you know by pl/sql cursors?

0 Answers  

can i use dbms_output.put_line in a function u are telling as return statement

7 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories