Difference Between View And Index ?

1.	Difference Between View And Index ?
Answer» View will not any data.. It only shows a data from table while Index has a Indexing Data for a sequence on which Index is created. View is similar to LOGICAL file without having Key and Index is similar to Logical File having Key (as keyed logical file has access PATH data) Table is similar to PF. View will not any data.. It only shows a data from table while Index has a Indexing Data for a sequence on which Index is created. View is similar to Logical file without having Key and Index is similar to Logical File having Key (as keyed logical file has access path data) Table is similar to PF.

Answer»

View will not any data.. It only shows a data from table while Index has a Indexing Data for a sequence on which Index is created. View is similar to LOGICAL file without having Key and Index is similar to Logical File having Key (as keyed logical file has access PATH data) Table is similar to PF.

View will not any data.. It only shows a data from table while Index has a Indexing Data for a sequence on which Index is created. View is similar to Logical file without having Key and Index is similar to Logical File having Key (as keyed logical file has access path data) Table is similar to PF.

Discussion

No Comment Found

Related InterviewSolutions

What Is The Purpose Of The "n" In The Following Calculation Specification?
How Can You Detect Overflow For A Print Program That Prints Multiple Lines Per Cycle?
How Can You Detect And Handle A Record Lock Situation?
When Would You Use Or Not Use This Approach?
Define The Purpose/use For Sflrna?
What Is The Difference Between Sflclr And Sflinz?
What Are The Different Types Of Variables Available In Cl?
Explain The Difference Between Defining Subfile And Message-subfile?
How To Toggle Between Single Line And Multi - Line Display Of A Particular Record In A Subfile?
What Is The Use Of Sflend Keyword?