answersLogoWhite

0


Best 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

User Avatar

Wiki User

15y ago
This answer is:
User Avatar
More answers
User Avatar

AnswerBot

7mo ago

In SQL, a view is a virtual table based on the result set of a SQL statement, which can be queried like a table. An index is a data structure that improves the speed of data retrieval by providing quick access to the rows in a table based on the indexed column(s). Views are used to simplify query complexity, while indexes are used to optimize data retrieval performance.

This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: What is the Difference between view and index in sql?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Continue Learning about Information Science

Which command is used to remove an index from the database in SQL?

It may depend on what flavor of SQL, but whenever you want to get rid of something, DROP is generally your friend. DROP INDEX <indexname>; is likely to be the command needed, with various options depending on, again, exactly what flavor of SQL you're talking about.


What are the differences between Pervasive SQL and MS SQL?

Pervasive SQL is a relational database management system designed for embedded applications, while MS SQL, or Microsoft SQL Server, is a full-fledged RDBMS with advanced features for enterprise applications. MS SQL provides more robust scalability, security, and integration options compared to Pervasive SQL. Additionally, MS SQL is commonly used in larger organizations, while Pervasive SQL is often utilized in smaller businesses and embedded systems.


What is the difference between sql and an sql server?

SQL stands for Structured Query Language and is a programming language used to manage and manipulate relational databases. An SQL server, on the other hand, is software specifically designed to store, retrieve, and manage data based on SQL queries. SQL is the language used to interact with an SQL server.


What are the SQL instances?

SQL instances are individual running copies of the SQL Server software, each with its own system databases and user databases. They are used to segregate and manage multiple databases on a single SQL Server. Instances allow for better utilization of server resources and provide a level of isolation between different sets of databases.


What is the difference between stored procedure and index?

A stored procedure is a precompiled set of SQL statements that can be executed repeatedly, helping to streamline database operations and improve performance. On the other hand, an index is a database structure that increases the speed of data retrieval operations by quickly locating the rows in a table. Stored procedures are used to encapsulate logic for performing tasks, while indexes are used to optimize data retrieval.

Related questions

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 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


Difference between sql and sql plus?

SQL*PLUS is a interface between user and Oracle database. It Provide an environment to use the SQL which is a query language to communicate with oracle database


Difference between sql server 2003 sql server 2005?

There is no such thing as SQL Server 2003. Microft released SQL Server 2005 as the next version of SQL Server 2000.


What is the difference between quel SQL and qbe?

gand maro...is the answer


What is index in sql?

Index is a data structure that improve the performance of data.


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 standalone component but an index cannot. Indexes are built on top of tables and cannot exist without tables.


Difference between SQL Exception class and SQL Warning class?

sql exception which provides information on database access errors where as sql warning provides inforamation on database access warnings.


Which command is used to remove an index from the database in SQL?

It may depend on what flavor of SQL, but whenever you want to get rid of something, DROP is generally your friend. DROP INDEX <indexname>; is likely to be the command needed, with various options depending on, again, exactly what flavor of SQL you're talking about.


Difference between oracle 10g and sql in points?

god only knows


How do you change the design of a query in Access?

You can do it in the Design Grid in Design View or you can do it through SQL view if you know how to use SQL.


What does SQL CREATE VIEW achieve?

SQL CREATE VIEW achieves the creation of a table or tables in the SQL database. One can then create tables to the purpose they desire and fill them in with information.