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 >> DB Administration
  2. Suggest New Category

Query processing is slow(eg select query)how will u solve that

Question Posted / franklin.2710

Answers were Sorted based on User's Feedback



Query processing is slow(eg select query)how will u solve that..

Answer / kumarayyalusamy

We will tune that query

Is This Answer Correct ?    7 Yes 2 No

Query processing is slow(eg select query)how will u solve that..

Answer / jayesh

WE CREATE PROCEDURE THEN ACCESS IT
INDEXING ALSO DONE

Is This Answer Correct ?    5 Yes 2 No

Query processing is slow(eg select query)how will u solve that..

Answer / mohapatra.gouranga@gmail.com

1) Find the cost.
2) Check what tables are going full table scan.
3) Create Indexes if is possible.
4) Re-write the query to optimize the cost with modifying
filter condition.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More DB Administration Interview Questions

What is fill factor? : sql server DBA

0 Answers  

What column differentiates the V$ views to the GV$ views and how?

3 Answers  

deleted of control file how will u recover control file?

4 Answers   CTS,

How would you determine what sessions are connected and what resources they are waiting for?

2 Answers  

What is a deadlock and what is a live lock? How will you go about resolving deadlocks?

1 Answers  

List out some of the requirements to setup a sql server failover cluster.? : sql server DBA

0 Answers  

What is the difference between clustered and non-clustered index? : sql server DBA

0 Answers  

How would you best determine why your MVIEW couldn't FAST REFRESH?

0 Answers  

Q. How to set ORACLE_HOME to my oracle software directory. Hi Friend I am installing oracle 10g Express Edition on Linux Fedora Core 6. Installation is success but when i run #sqlplus I getting command not found error. Then I have search sqlplus .i.e # find / -name sqlplus /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/sqlplus /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/sqlplus These above output from find i have doubt which is correct path of sqlplus. So doubtfully i have set path 1st one.i.e # PATH=$PATH:/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin Then I have run #sqlplus but still i have problem following Error 6 initializing SQL*Plus Message file sp1<lang>.msb not found SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory How overcome this please answer m???

1 Answers  

. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?

0 Answers  

What view would you use to determine free space in a tablespace?

3 Answers  

Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.

0 Answers   Infosys,

For more DB Administration Interview Questions Click Here
Categories