Interested to Buy Any Domain ? << Click Here >> for more details...
What is an index?
- 8 Answers
- 15433 Views
- Yardi Software, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / krishna chaithanya
index allows to search record in a table making the search
meachnism faster and effective
| Is This Answer Correct ? | 14 Yes | 1 No |
Answer / sanjay mukati
Index is a such type of mechanism in which records are
searched and fetched efficiently and fastly in a table. It
is physical address of data.
Two type of index :
A. Cluster Index
B. Noncluster Index
| Is This Answer Correct ? | 8 Yes | 2 No |
Answer / dharmendra k dixit
INDEX are physical address of data, its is same just we
Have indexes in our Book..through this we can make our
search much faster.
in Idle way always try to make Indexes on that Column which
have Integer Value(i.e. Not on text type).
There are two types of Indexes in SQL SEREVR
1. Clusterd Index.(Create automatically if there is a
Primary key on Table)
2. Non Clusterd Index.
| Is This Answer Correct ? | 7 Yes | 2 No |
Answer / mandar kavishwar
Indexes in databases are similar to indexes in books. In a
database,an index allows the database program to find data
in a table without
scanning the entire table.
There are two types of Index in MS-SQL.
1.Clustered
2.Non-Clustered
In MS-SQL Server 2005,
Only 1 Clustered & 249 Non-Clustered Possible.So (Total 250)
But in MS-SQL Server 2008,
Only 1 Clustered & 999 Non-Clustered Possible.(Total 1000)
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / shrikant kalwade
Index means we create unique id to record in to the table.
primary key is example of index; using proper index we
search perticular record from database fast and accurate.
| Is This Answer Correct ? | 4 Yes | 3 No |
Answer / sovan guha
An index is a physical structure containing pointer to the
data.Index are created in an existing table to locate rows
more efficiently and quickly.
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / aman popli
Indexes in SQL Server are similar to the indexes in books.
They help SQL Server retrieve
the data quickly.
There are clustered and nonclustered indexes.
A clustered index is a special type of index
that reorders the way in which records in the table are
physically stored. Therefore table
can have only one clustered index. The leaf nodes of a
clustered index contain the data
pages.
A nonclustered index is a special type of index in which
the logical order of the index
does not match the physical stored order of the rows on
disk. The leaf node of a
nonclustered index does not consist of the data pages.
Instead, the leaf nodes contain
index rows.
| Is This Answer Correct ? | 3 Yes | 2 No |
Answer / nalini
index is a physical address of the data.Index having 2
types.
1) cluster index
2)nonclustered index
| Is This Answer Correct ? | 2 Yes | 3 No |
Why we should not use triggers?
What is the difference between primary key and unique constraints?
how to take backup bcp out for a column in table in sql server?
What are xml indexes?
There is table like Events...in that name ,startdate ,enddate,location are the column names write a stored Procedure for this table to get events by Months "GetEventsByMonths"
Write an SQL query to obtain the 2nd highest salary.
0 Answers Akamai Technologies,
What is an Index?
What is the difference between NOROW and LOCKROW?
0 Answers Accenture, Honeywell, Satyam,
How to execute function in stored procedure sql server?
What is unique key constraint?
how to generate XML out of QUERY?
write the query for taking database backup in sql
10 Answers ABC, IBM, Logica CMG, MA,
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
