0
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 else can I help you with?
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?
The difference between Pervasive SQL and MS SQL are slight and of a rather technical nature. To the typical consumer the functionality is very much the same, though performance may vary depending upon the use.
What is the difference between sql and an sql server?
SQL is an abbreviation for Structured Query Language. SQL is a means to request data from a database. SQL is a standards based langage that has many versions approved by the American National Standards Institute (ANSI). There are many versions of ANSI-SQL and most databases support specific versions of ANSI-SQL. SQL Server is a database management system that was originally created by Sybase. Microsoft bought the rights from Sybase to market their own version of SQL Server on the Microsoft Windows operating system. Sybase still has versions of SQL Server on other operating systems. When people refer to SQL Server, they typically mean "Microsoft SQL Server." Microsoft SQL Server is a database management system (DBMS) that utilizes SQL (or more specifically Transact-SQL, or T-SQL) as a means to extract data from it's database tables.
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?
As stored procedure in procedural code, which usually calculates or changes some data. An index is a database object which aids in quick location of records because it is internally ordered in a optimized way for the specific key
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 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.
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.
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
Which date function is used to find the difference between two dates in SQL?
datediff
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.
