Playing with Internet

Indexing Tables : Building block of performance tuning, an overview DEFINITION: An INDEX is a schema object that contains an entry for each value that appears in the indexed column(s) of the table and provides direct & fast access to rows(i.e. table records). INDEX is nothing but to create a logical relationship table (i.e. index table) where the mapping of indexed value of all the table records and ROWID is captured. Index table is totally different from normal table where latter contains the actual data but former is a logical mapping table which is mentioned above in order to quickly retrieve the table records. Index table doesn’t contain any actual data. Index table can be read or written only by Oracle. DB users can’t understand/ or view the index table since it is in oracle readable format. Index can be created on a single column or on a combination of multiple columns. More than one index table can be created for a single data table. Index is mainly used to improve the p

Hi all, This is my first post for the world of blogging, so I like to introduce myself first. I belong to a family of soldiers and farmers, so I am deeply related to the roots of our Indian culture. I love playing with internet, either it is some freaking PC game or world wide web, I always enjoy sitting in front of my laptop. My laptop is my baby, and best friend of mine, when its connected with the world. I love playing all kind of flash games. Without Google and Yahoo, internet will be nothing. Yeah, Facebook made a considerable growth in the world of internet. Trying to get the business from the Google. But, its none of my business, I still love Google and Internet and enjoy Google tools. Yahoo Messenger is my favorite time pass these days. Working with Oracle on a Finance Project, don't want to mention much about the project here, as its against the company norms. But love playing with Java and Hibernate, and always keen to implement new ideas which help the banking worl