answersLogoWhite

0

It provides a better and faster method to search a particular item you are looking for. When you issue a select statement to have a particular item with some condition, it searches the whole DB to get the answer for you. Instead if you have some indexes to it, the searching is done faster.

User Avatar

Wiki User

16y ago

What else can I help you with?

Related Questions

What is the means drop command in sql?

The DROP command allows you to delete things such as tables or indexes.


Why does SQL allow duplicate tuples?

There are many reasons why SQL allows duplicate tuples (rows):To store non-unique values.To simply remove primary keys, unique indexes, and unique constraints.It allows this if there is no unique constraint.


What tasks are included in database maintenance?

Back Up Database Task Performs different types of SQL Server database backups. Check Database Integrity Task Checks the allocation and structural integrity of database objects and indexes. Execute SQL Server Agent Job Task Runs SQL Server Agent jobs. Execute T- SQL Statement Task Runs Transact-SQL statements and more


How do you use SQL?

You use SQL by issuing commands to an SQL server, either directly by you or by a program you are using.


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


What are SQL data types used for?

There are many purposes behind 'SQL' data types. The most common use of 'SQL' is with website programming and hosting services, as well as HTML coding.


Whether you need to update to use SQL 2000 or SQL 2005?

yes definitely you need to update


Do you need sql and c plus plus to code in them in Visual Studio?

Connect to a SQL Server, query with Transact-SQL (T-SQL), and view the results with the mssql plugin for Visual Studio Code. The SQL Database projects extension for VS Code comes with the mssql extension, which supports SQL projects on Windows, macOS, and Linux. To learn more about data science please visit- Learnbay.co


What type of database does WikiAnswers use?

My SQL


Who are users of SQL programming?

The users of SQL Programming include database administrators(DBAs) and application developers. They use SQL programming to do daily tasks efficiently and correctly.


Can you use SQL to pull data from Oracle?

yes.... example: select *from employee; dml command in sql language


What would someone use MS SQL hosting for?

MS SQL stands for Microsoft SQL. SQL, or Structured Query Language, is a way to extract information from a database, as well as to update, add and remove information from a database. Companies with databases of customers or purchase records may use MS SQL hosting to keep track of their business activities or customer relationships.