Interested to Buy Any Domain ? << Click Here >> for more details...
Query processing is slow(eg select query)how will u solve that
- 3 Answers
- 7894 Views
- TCS, I also Faced
- E-Mail Answers
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
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
what is a crs resource?
How would you go about verifying the network name that the local_listener is currently using?
suppose you want to audit specific activities on sensitive data. How can you achieve that?
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
Where would you look for errors from the database engine?
Where do you find the default index fill factor and how to change it? : sql server DBA
what is the last version,the release date of that version and fix pack of ibm db2 udb?
What is the difference between dropping a database and taking a database offline? : sql server DBA
You create a private database link and upon
connection, fails with: ORA-2085: connects to
how can you process messages in order asynchronously?
What the different components in replication and what is their use? : sql server DBA
I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me
what is ora 24313?what is the procedure to exclude that error?
