Can any one tell me how to increase the performance of a
sql query ie what are the performance tips in creating or
writing a sql query !!?
Answer Posted / manoj
1.
Use proper sequence of tables in from clause
i.e.
the table have more common column must in last
in form clause bcoz on firing of query engine link
last table in form clause
2.
Use "Exist" clause instead of "Not in"
Bcoz it return only true/false(boolean)
3.
Use "Hint" if Required
Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
Which is better join or subquery?
How do you know if a relationship is 2nf?
How do you update f as m and m as f from the below table testtable?
What are the advantages of sql?
Mention what does plv msg allows you to do?
Can a procedure in a package be overloaded?
What is sql integrity?
What is a clob in sql?
How to call a javascript function from pl sql?
What are sql objects?
What are tables and fields in the database?
How to fetch values from testtable1 that are not in testtable2 without using not keyword?
Why indexing is needed?
Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence. flat file product Prono,pro_name, 1, 20 watt tube light 2, 30 watt tube light & target should be like 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights. 104, 20 watt tube light 105, 30 watt tube light thks reg suvarna joshi suvarnaatsuvarna@rediffmail.com
What is raid? How does it help storage of databases?