Query processing is slow(eg select query)how will u solve that
Answer Posted / 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 View All Answers
Query processing is slow(eg select query)how will u solve that
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
how can you communicate with operating system files from oracle?
How would you extract DDL of a table without using a GUI tool?
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
What are the commands you'd issue to show the explain plan for "select * from dual"?
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
What are the operating modes in which database mirroring runs? : sql server DBA
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
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 are the different types of upgrades that can be performed in sql server? : sql server DBA
what is the diffrence between core dba and apps dba?
What authentication modes does sql server support? : sql server DBA
What are the different sql server versions you have worked on? : sql server DBA
what is the last version,the release date of that version and fix pack of ibm db2 udb?