how to tune oracle sql queries pls tell me step by step.
urgent pls
Answer / define
You can use pl/sql query profiler in dbForge Studio for Oracle. It helps to tune oracle sql performance very much.
| Is This Answer Correct ? | 0 Yes | 1 No |
What is self-referential integrity constraint ?
difference between procedures and function?
How to synchronize 2 schema's objects?
What is a Public Synonyms ?
Explain the use of rows option in exp command.
i have a table and it has constraints and i want to get "ALTER TABLE table_name ADD CONSTRAINT constraint_name constraint type" this code must be in string type please help me if you want, i can give more explainings
Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun
SELECT THE RECORDS FROM 3 TABLES LIKE(T1,T2,T3) AND HOW CAN WE INSERT THAT RECORD IN ANOTHER TABLE LIKE(T4)?
what is difference between table and view? where to use views? thanks in advance!
Why required to run root.sh at the time of installation and what exactly it will do
Q) How to Find Max Date from each Group? (Asked in Infosys (INFI)Interview)
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,