Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

OS command

Indraa BanerjeeApr 2 2014 — edited Apr 2 2014

Hi,

I have a file test_indra.txt that cotains WINScp command.

Now from Command promt i need to write below two line to execute it.

cd   C:\Program Files (x86)\WinSCP

WinSCP  /script="test_indra.txt"

Can you help me to execute it via ODI using OS command.

If I write cmd c/ C:\Program Files (x86)\WinSCP  it does not work.

Please help.Its urgent!!!


Comments

sb92075
Please realize that we don't have your tables & we don't have your data.
Therefore only YOU can run bechmark tests to see for yourself what produces the better results.
EdStevens
userPrasad wrote:
I am using oracle 10g. I have a table with huge data. There are 4 indexes on this table with combination of columns. All the indexes are created using the script like -
CREATE INDEX INDX1 ON My_TABLE
(ID, emp_NUMBER, emp_sal, emp_div)
TABLESPACE my_IDX
PCTFREE 10
INITRANS 2
MAXTRANS 255
NOLOGGING
NOPARALLEL;

CREATE INDEX INDX2 ON My_TABLE
(ID, emp_NUMBER, emp_name)
TABLESPACE my_IDX
PCTFREE 10
INITRANS 2
MAXTRANS 255
NOLOGGING
NOPARALLEL;

and so on...
Few columns are always there in every index like Id, emp_number.

Most of the select queries are using the id and emp_number in the where clause criteria's. SQL "select" performance is not very good and need to find some kinda solution to this problem .

Shall I create one index using all the columns present in various indexes instead of various indexes with different combination of the columns ?
CREATE INDEX INDX2 ON My_TABLE
(ID, 
 emp_NUMBER, 
 emp_name)
and

CREATE INDEX INDX2 ON My_TABLE
(emp_name, 
 emp_number,
 ID)
Both have the same collection of columns, but they most defianetly do not serve the same purpose. Once you understand that, you will have your answer.
1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 30 2014
Added on Apr 2 2014
2 comments
144 views