Interested to Buy Any Domain ? << Click Here >> for more details...
can you explain performance tunning in oracle(sql,PL/SQL)
- 2 Answers
- 4660 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sushant
It is just to check whether the query which we provide is
quiet simple n takes less time to compile as compared to
other querys !!!
Mostly its a DBA part !!
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / sudipta santra
First u need to take explain plan of the proposed query then
you can identify for which join condition is costlier. By
watching this then you can modify the condition logic of the
query.
There are so many logic for make a query tune.
| Is This Answer Correct ? | 1 Yes | 0 No |
Can we convert a date to char in oracle and if so, what would be the syntax?
What are various joins used while writing SUBQUERIES?
What is a tns service name?
When do we use group by clause in a sql query?
3. Display all the client numbers in the ORDER table. Remove duplicates.
How to export data with a field delimiter?
how to get count of tables in particular database in Oracle?
1. How actually index will work ? 2. Why do people prefer mostly bitmap index and btree index in datawarehouse ? 3. If I use the column in aggrigate functions like max,min,count and avg and if I have a index created on that column, will it increases the performance ?
The join defined by the default data link is an outer join yes or no ?
Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.
I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance
Is there a function to split a string in plsql?
Oracle General 
