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

Answer Posted / jayesh

WE CREATE PROCEDURE THEN ACCESS IT
INDEXING ALSO DONE

Is This Answer Correct ?    5 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

suppose you want to audit specific activities on sensitive data. How can you achieve that?

951

What are the different types of database compression introduced in sql server 2008? : sql server DBA

1040

what functionality does oracle provide to secure sensitive information?

942

I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB

1885

How do you troubleshoot errors in a sql server agent job? : sql server DBA

1051

What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA

987

Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

2096

I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution

2044

how can you connect from 10g user to 11g user??

2062

What are the different types of indexes available in sql server? : sql server DBA

1110

what is the use of recording information about current session?

995

what is ora 24313?what is the procedure to exclude that error?

2519

What are the different sql server versions you have worked on? : sql server DBA

964

What the different topologies in which replication can be configured? : sql server DBA

1180

Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.

2112