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
what do you understand by fine-grained auditing?
what is the use of ocr?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
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 performance views in an oracle rac environment?
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
how can you get actual data change values from previous transactions in oracle?
What is a correlated sub-query? : sql server DBA
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
What the different topologies in which replication can be configured? : sql server DBA
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
which background process invoke at the time of upgradation tell me???
how can you implement fine-grained auditing?