Query processing is slow(eg select query)how will u solve that
- 3 Answers
- 7184 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
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
What authentication modes does sql server support? : sql server DBA
which background process invoke at the time of upgradation tell me???
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
who owns the operating system files created by the utl_file package?
Query processing is slow(eg select query)how will u solve that
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
What the different types of replication and why are they used? : sql server DBA
how can you enable flashback feature?
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
How do you open a cluster administrator? : sql server DBA
What are the different types of upgrades that can be performed in sql server? : sql server DBA
what do you understand by fine-grained auditing?
