Home » SQL & PL/SQL » SQL & PL/SQL » Indexing (Oracle 10G)
Indexing [message #359337] Sat, 15 November 2008 00:06 Go to next message
Messages: 122
Registered: July 2008
Location: bangalore
Senior Member
Dear All,
I have two tables named supplier and product,where i have a column name called Productid in both the tables.There is in need that ,I have to make a join with these two tables based on productid.Whether i can place an index for both the tables on productid.

Thanka & Regards,
Re: Indexing [message #359341 is a reply to message #359337] Sat, 15 November 2008 01:03 Go to previous message
Michel Cadot
Messages: 65155
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can.

Previous Topic: where condition based on column value
Next Topic: Need help in writing query (merged)
Goto Forum:

Current Time: Thu Aug 24 05:49:46 CDT 2017

Total time taken to generate the page: 0.19854 seconds