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: 64107
Registered: March 2007
Location: Nanterre, France, http://...
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: Mon Dec 05 04:36:08 CST 2016

Total time taken to generate the page: 0.13123 seconds