Interested to Buy Any Domain ? << Click Here >> for more details...
Query processing is slow(eg select query)how will u solve that
- 3 Answers
- 7896 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
Why would you use sql agent? : sql server DBA
Explain materialized views and how they are used.
what are the differences of where and if in SAS?
Why would you call update statistics? : sql server DBA
how can you generate profile of pl/sql applications to identify performance bottlenecks?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit
What is replication? : sql server DBA
What are the commands you'd issue to show the explain plan for "select * from dual"?
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
How do you troubleshoot errors in a sql server agent job? : sql server DBA
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
when does an alert gets signaled?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
how can you connect from 10g user to 11g user??
