Home » SQL & PL/SQL » SQL & PL/SQL » Indexing (Oracle 10G)
Indexing [message #359337] Sat, 15 November 2008 00:06 Go to next message
aviva4500
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,
Hammer.
Re: Indexing [message #359341 is a reply to message #359337] Sat, 15 November 2008 01:03 Go to previous message
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
You can.

Regards
Michel
Previous Topic: Create files from Oracle Procedure
Next Topic: Need help in writing query (merged)
Goto Forum:
  


Current Time: Fri Feb 07 16:11:44 CST 2025