Interested to Buy Any Domain ? << Click Here >> for more details...
How would you optimize a slow SQL query?
- 1 Answers
- 2995 Views
- I also Faced
- E-Mail Answers
• Use EXPLAIN PLAN to analyze query performance.
• Add indexes where needed.
• Avoid using SELECT *; instead, select specific columns.
• Use proper JOINs and avoid unnecessary computations.
• Optimize queries using caching and denormalization if necessary.
| Is This Answer Correct ? | 0 Yes | 0 No |
emp numb is unique because that is primary key,,but what is foreign key .. explain very clear with example
how to get second highest sal of emp table
2. Display the item number and total cost for each order line (total cost = no of items X item cost). Name the calculated column TOTAL COST.
How to convert times to characters in oracle?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
What privilege is needed for a user to create indexes in oracle?
how many outer joins are used in a single sql query? is there any limitations for using of outer joins?
2 Answers BOB Technologies, Cap Gemini, IBM,
why should i declare foreign key constraint as self relation instead of binary relation in tables ?
various types of hints and their usage
what is query and types of query
what are the mandortary parameters required for cuncurrent program definition in oracle apps R12?
What are the components of logical database structure in oracle database?
Oracle General 
