Interested to Buy Any Domain ? << Click Here >> for more details...
Query processing is slow(eg select query)how will u solve that
- 3 Answers
- 7913 Views
- TCS, I also Faced
- E-Mail Answers
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
what do you understand by fine-grained auditing?
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
How do you trace the traffic hitting a sql server? : sql server DBA
What is the difference between dropping a database and taking a database offline? : sql server DBA
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
what are the differences of where and if in SAS?
what is ora 24313?what is the procedure to exclude that error?
Explain materialized views and how they are used.
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.
What the different topologies in which replication can be configured? : sql server DBA
What are statistics, under what circumstances they go out of date, how do you update them?
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
Why would you call update statistics? : sql server DBA
What types of replication are supported in sql server? : sql server DBA
