GeekInterview.com
Series: Subject: Topic:
Question: 157 of 178

Why External Sort is more efficient than Internal sort?

Asked by: Interview Candidate | Asked on: Jul 26th, 2006
Showing Answers 1 - 6 of 6 Answers
srilkrishy

Answered On : Aug 28th, 2006

View all answers by srilkrishy

Hi,For internal sort,you need to code a program by specifying the sort criteria and that the program need to be compiled and linked.But in case of External sort,there is no need for coding the program.Moreover you can change the sort criteria just by changing the sort parameters that passed thru the SYSIN card.So the external sort is more efficient compared to internal sort.In case of internal sort,if you want to modify the SORT criteria,you need to repete the entire procees of changing the program,compile and linking it.Thank youKrishy

  
Login to rate this answer.
rajesh

Answered On : Aug 31st, 2006

Hi,For internal sort,you need to code a program by specifying the sort criteria and that the program need to be compiled and linked.But in case of External sort,there is no need for coding the program.Moreover you can change the sort criteria just by changing the sort parameters that passed thru the SYSIN card.So the external sort is more efficient compared to internal sort.In case of internal sort,if you want to modify the SORT criteria,you need to repete the entire procees of changing the program,compile and linking it.rajesh

  
Login to rate this answer.
jayakumar

Answered On : Sep 9th, 2006

What you said is ok,but what is the real reason of using the internal sort,at which time the internal sort (PLISRTA) is really needed?

  
Login to rate this answer.
HEMANTKUMAR BPRASE

Answered On : Sep 16th, 2006

External sort is more efficient than internal b'coz it is faster process. it takes less time.

  
Login to rate this answer.
manoj

Answered On : Sep 28th, 2006

 There are two ways to do sorting :  1. Cobol program - sort statement2. using JCL  sorting using cobol prog called as internal sort and sorting using jcl called as external sort.  Offcourse , External sort is better because we can sort a file in 4 steps only. In internal sort we have to write complex code.  As a programmer i use short cut method but it depands upon the work.thanksmanoj.

  
Login to rate this answer.
memays

Answered On : Nov 11th, 2007

View all answers by memays

Technically, an External sort is more efficient and can utilize I/O slighltly better than an internal sort, however in a typical environment, files are sorted so they can be input to another program which requires them to be in a specific sequence. The External sort would require the file to be passed 3 times:   Input to Sort, Output from Sort, Input to program that passes the data.An Internal sort will only require the file to be passed 1 time: Input to application with Internal sort. When taking this into consideration, from an overall processing efficiency viewpoint, the INTERNAL sort would be much more efficient, as the difference in sorting speed would be more than offset by the time it would take to read/write/read the file using an external sort.

  
Login to rate this answer.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Related Open Questions

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Question Categories

CICS Interview Questions

COBOL Interview Questions

DB2 Interview Questions

IDMS Interview Questions

JCL Interview Questions

VSAM Interview Questions

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.