Interested to Buy Any Domain ? << Click Here >> for more details...
how to code performance tuning of oracle PL/SQL? can any body
send me the perfect answer?
- 1 Answers
- 5414 Views
- IBM, I also Faced
- E-Mail Answers
Answer / kt
There isn't any hard and fast rule for code optimization. U have to analyze the situation and act accordingly. :)You can either choose an RBO (Rule based optimization) or a CBO (Cost based optimization).But before that one of the simplest way to make ur queries faster is Indexing.
If your database table is huge and simple select statement takes ages to come out then you can go for Indexing of the table.For that u have to analyze which column to index. Generally we should index the column that we frequently use in our where clause. then you need to know what type of index to use. Default one is B* Tree.U can go for index on as many columns as u like but keeping the fact in mind that too much column indexing also eats some space of data dictionary.
Then you can also go for table partitioning, analyze statement, dbms stats gathering and so on.
| Is This Answer Correct ? | 1 Yes | 1 No |
How to use subqueries with the in operator using oracle?
I have a table emp. There is only one column in the table. In that , there are only three rows in that column. The value in the first row is 'A' and the value in the second row is 'B' and the third row is 'C'. Now, my question is , How will you write a select query to display the output as B C A Note: order by cannot be used coz it gives us output as CBA. But the output should be BCA.
Can we create index on views?
19 Answers CTS, Syntel, TCS,
What is a parameter file in oracle?
How do I know if oracle is installed on windows?
how do u know the total no of rows in a table?
How to execute a stored procedure in oracle?
How can one skip any number of rows while loading the DB tables with SQL Loader? Similarly how can one skip any column?
Differentiate between translate and replace?
How to view the data files in the current database?
How can you Enforce Referential Integrity in snapshots ?
What is a database schema in oracle?
Oracle General 
