Home » SQL & PL/SQL » SQL & PL/SQL » indexes
indexes [message #264523] Mon, 03 September 2007 11:35 Go to next message
rsreddy28
Messages: 295
Registered: May 2007
Senior Member
Hello All,

Can I create an index on two tables at a single time, like

SQL> create index idx on emp(ename,empno),dept(deptno,dname) .

I have tried the above one , but error came.

kindly let me know.

Regards,

Raj
Re: indexes [message #264524 is a reply to message #264523] Mon, 03 September 2007 11:36 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
>Can I create an index on two tables at a single time
NO
Re: indexes [message #264526 is a reply to message #264524] Mon, 03 September 2007 11:41 Go to previous message
rsreddy28
Messages: 295
Registered: May 2007
Senior Member
Thank you SIR
Previous Topic: how to populate owa_util.ident_arr and dbms_sql.varchar2_table (merged)
Next Topic: Help Needed with a subquery
Goto Forum:
  


Current Time: Wed Dec 07 10:54:33 CST 2016

Total time taken to generate the page: 0.07506 seconds