Interested to Buy Any Domain ? << Click Here >> for more details...
How would you optimize a slow SQL query?
- 1 Answers
- 3162 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 |
what's query optimization and without use of IN AND Exist can we get another way data from query
Can we create more than one index on particular column?
Define oracle database
what is analyze command ? what kind of statistics does it generate?
There is a big table with "n" of rows and 40 + columns .It doesn't have primary key.How do you select the primary key. In other words how do you get the duplicate records.
Explain constraining triggers.
what is the syntax of SELECT command?
How to update values on multiple rows in oracle?
How to bring a tablespace offline?
what is the difference between sql& oracle?
How does Oracle guarantee data integrity of data changes?
how to get required data from oracle source is like this ram_05_seetha lax_05_viswa bamr05frummy run_01_away sw_sas_trim i want my target data like ram_05_seetha lax_05_viswa to get data using %_05_% but it will give ram_05_seetha lax_05_viswa bamr05frummy how can i get my target data?
Oracle General 
