Monthly Archives: December 2012

Rebuild Index Online

Rebuilding Indexes Online You can create or rebuild indexes even when doing DML (INSERT/UPDATE/DELETE) statements on the base table. However, rebuilding during low DML activity is still better. Prior to Oracle 11g, this required an exclusive lock at the beginning and end … Continue reading

Posted in Uncategorized | Tagged , | Leave a comment

Types of Indexes

Types of Indexes The following is a list of indexes discussed in this section: B-tree Bitmap Hash Index-organized table Reverse key Function-based Partitioned (local and global) Bitmap join indexes I will give example of each one of them in the … Continue reading

Posted in SQL | Tagged , , | Leave a comment

Using Histogram

Using Histograms Histograms record the distribution of data when you analyze a table or index. With this information in hand, the cost-based optimizer can decide to use an index for conditions it knows will return a small number of rows and … Continue reading

Posted in Uncategorized | Leave a comment

Using Not Equals Operator

select * from table_name where city <>’Sunnyvale’;

Posted in Uncategorized | Tagged , , | Leave a comment

Finding our url of database

select user();This will show the user info username and port numbershow variables;This will show other db info like port number etc..

Posted in Uncategorized | Leave a comment

Issues with eclipse not starting or JVM Issues

This is usually an issue in the below scenarios: (1)When you downloaded 32 bit eclipse on 64 bit machine or (2)When you are using 64 bit java on 32 bit machine Below are some of the things that I tried … Continue reading

Posted in Uncategorized | Leave a comment

Using Mockito Objects in Java

Ist step is to download mockitoall.jar from http://code.google.com/p/mockito/ If you are using Eclipse,add it to your build path from Configure Build Path Below is the sample example using Collections .In the second iteration ,I am testing for the iterator object. package … Continue reading

Posted in Uncategorized | Leave a comment