Answers.com > Wiki Answers > Categories > Technology > Computers > Computer Programming > Database Programming > What is the Difference between view and index in sql?

What is the Difference between view and index in sql?

In: Database Programming [Edit categories]

Answer:

Both Views and Indexes are created on top of a table but each of them serve a specific purpose.

An Index is a data structure that is created to improve the performance of the data fetch operations on a table

A view is similar to a table but may contain data from one or more tables connected to one another through a business logic. A view can be created to implement business logic or to conceal the underlying table implementation from everyone

First answer by Anandvijayakumar. Last edit by Anandvijayakumar. Contributor trust: 783 [recommend contributor ]. Question popularity: 1 [recommend question].

[report abuse]

Can you answer these Database Programming questions?

	What different between database and spreadsheet?	Answer it!
	What are the software available in the market today for database application?	Answer it!
	What is a filing system and its features?	Answer it!
	What is the topic for management information system project?	Answer it!
	What does Row Detail determine in database?	Answer it!

Relevant answers:

Difference between table and index in sql?
A table is a collection of data that is organized into rows and columns. An index is a data structure that improves the performance of data fetch operations on a table. A table can exist as a...
What is the difference between T-sql and sql?
T-SQL is Microsoft's version of the generic SQL langauge to be used with, for example, Microsoft SQL Server.
What are the differences between Oracle and SQL?
Oracle is an RDBMS aka Relational Database Management System and SQL (Structured Query Language) is a programming language.
What is the difference between hql and sql?
one of the difference is HQL does not support distinct but SQL supports the distinct in the query
What is the difference between sequel and SQL?
The definition of the word Sequel is "that which follows in consequence of what has previously happened" Ie. The Godfather 2 was the sequel to The Godfather. SQL on the other hand, was originally an...