answersLogoWhite

0

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.

User Avatar

Wiki User

15y ago

What else can I help you with?

Related Questions

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 is the Difference between view and index in sql?

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


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.


What is the difference between delete and truncate statement in SQL Database?

Delete statement deletes only the data from the table but you can apply some condition and only part of the data can be deleted. Truncate empties entire table. Drop deletes the table itself.


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.


What is hash table in sql?

temp table


Sql select to return one value?

It depends on the DBMS MSSQL: SELECT TOP 1 column FROM table MySQL: SELECT column FROM table LIMIT 0,1 (start index, number of rows to get)