Wipro WASE 2006

Wipro WASE is a 4 year MS program from BITS ,Pilani , with the full fee borne by the IT giant Wipro plus an attractive stipend every month.
Interested candidates need to apply here (within a week).Selected candidates will be called for a test conducted at 5 or 6 major cities.
Eligibility : BSc(CS/IT/Electronics/Physics/Maths/Statistics)/BCA/BCM students .......
For More Details please refer other details or This wednesdays Time Of India

Table Indices

Consider the sample Table empTable and a select * from empTable fetched me the following results. It shows the rows are organized by the LastName column. For information, LastName is my Clustered Index key. For now this is the only index I have on this table.

Now Issue the following query "select * from emptable where age BETWEEN 16 AND 19".This will fetch me the following data.

But the point of concern here is performance and the usage of indices.To knows it I enquired for the estimated execution Plan.

It shows as below: Here it is scanning the table which is organized by the Clustered index. This is very much similar to table scan. The cost field shows 0.03767 units.

With an Index on Age field

Try to create an index on the column Age. Issue the previous query again, now, the estimated execution Plan is shown as below. It is split into to two tasks
1) Index Seek
Index seek goes through the Index structure which we created for the column and notes down the ROWIDs or Clustering Keys of the rows in table matching the selection criteria.
2) BookMark Lookup. Uses this ROWIDs or Clustering Keys to fetch the actual row in the table.
The cost field shows: 0.00651 units.

How it works

When the query is passed to the database, based on the columns in the WHERE clause fields are compared against existing indices. In our case the WHERE clause contains the age and it matches the just now created Index. So it is should be selected.

The index structure will usually be some variant of B/B+ tree, with each node contains a pointer called ROWID or Clustering Key pointing to the physical location of the row in the table. This pointer can be used during the BookMark Lookup phase to fetch the row.
Obviously going through the Tree structure is quicker compared to scanning the entire table. Hence using indices will improve the performance.

Mobile Quiz

Today mobile phones have occupied an irreplaceable place in our daily life. People got so addicted to it that, it has become a major time pass activity to talk to someone via a Mobile phone and at any time it will be locked in one of our hands.....Be it good or bad, its not the concern of this article.....but mobile is now an invaluable gadget. Here is a 5 question quiz from rediff to test what we know about the mobile phones. Test yourself.
Mobile Quiz

Web2.0 Logo Creator

Create a logo for your weblog or site by entering the name of your site.It allows you to add simple Graphics like..reflections,Beta tag.You can also use it to create image form for your emails,etc.,
Test try it here: Web2.0 Logo
Related
Email Icon Generator

I Day Google Way

Wishing India all the very best.....

Windows Vista Beta2 CD

Answer the following easy to answer 8 questions and win the Windows Vista Beta2 CD.As this "Future Assured Quiz" is being hosted by none other than the mighty windows its for sure we gonna get it , if we answer all the questions correctly.

I gave my try and the following text appeared on my screen.
"Thank you for taking part in the Microsoft Future Assured Quiz.Your copy of Windows Vista Beta 2 CD will be dispatched shortly."
So Give your try now at Win a Vista

Blogger Beta

Today When I was trying to log in to Blogger.com ,I noticed two new things.
First
It allowed me to sign in with either the Blogger ID or my Google account.I have been waiting for this change for quite long time , as it will difficult to maitain to many accounts.I tried to sign in with my GoogleAccount.I got inside and I was asked if I could merge my Blogger account with my Google Account.
Second the Blogger Beta.The Beta version is promising a lot of new things such as ,Categorizing the Posts with labels,Controlling the appearance of the blog with mouse,etc.,To try all these ,existing Blogger users have to wait few more days...But it doesnt allow me to migrate and said "Could not Switch you to the new Blogger".It seems they are allowing limited number of (existing) users to try the Beta version at this time.

The New Users can directly try the Beta verison from here : http://beta.blogger.com/signup.g

For a tour of the Beta version http://www.blogger.com/beta-tour.g

Oracle Mobile Mail

For the employees of Oracle Corporation , mails can be accessed via Mobile also.For that you have to create an ID [which will be your mobile number] and a PIN and you mobile should be able to browse the mobile web.Recently I setup one for me.Follow the instructions below to setup one for you.

1] Signon to to your collabsuite : https://collabsuite.oracle.com/
2] Click the Hot link Push Mail/Mobile Data Sync Configuration.
3] This will take you to the "Oracle Collaboration Suite Mobile Preferences".
4] Now as shown in the snapshot below, please create an accout for you.The mobile Access Account ID should be your complete mobile number, i.e it should include your country code

5]Click Ok.Now you will get a confirmation message.
6] Now fast path the following address in your mobile browser https://collabsuite-mobile.oracle.com.
It will prompt you to enter the Mobile Access Account ID and Mobile Access Account ID.
7] If you have a high end mobile with enough memory , you even can install an email client application much like an Outlook.