Answer / sumit

Index Scan is nothing but scanning on the data pages from
the first page to the last page. If there is an index on a
table, and if the query is touching a larger amount of
data, which means the query is retrieving more than 50
percent or 90 percent of the data, and then optimizer would
just scan all the data pages to retrieve the data rows. If
there is no index, then you might see a Table Scan (Index
Scan) in the execution plan.

Index seeks are generally preferred for the highly
selective queries. What that means is that the query is
just requesting a fewer number of rows or just retrieving
the other 10 (some documents says 15 percent) of the rows
of the table.


In Index Scan the cost is proportional to the total number
of rows in the table. Thus, a scan is an efficient strategy
if the table is small or if most of the rows qualify for
the predicate.


In Index Seek the cost is proportional to the number of
qualifying rows and pages rather than to the total number
of rows in the table.

Answer / vasu

An index seek shows that the index is used in the table and
index scan shows that index is not used in table

I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration

0 Answers  

---

How to verify a login name with sqlcmd tool?

0 Answers  

---

What is right outer join in sql server joins?

0 Answers  

---

hi ..i am working as a sql dba.....now i want to learn more about t-sql..... is it possible to learn online.... plz refer any site ..thankq

0 Answers   IBM,

---

what information is maintained within the msdb database? : Sql server administration

0 Answers  

---

What is Online Index Rebuild Operation?

1 Answers  

---

What command would you use to add a column to a table in sql server?

0 Answers  

---

What is ms sql server triggers?

0 Answers  

---

What does the on delete cascade option do?

0 Answers  

---

can anyone explain me the concept of Serialization in Detail and Clear? plz its urgent i have interview on friday (15th feb)

1 Answers  

---

Explain basic SQL queries with SELECT from where Order By, Group By-Having?

3 Answers   TetraSoft, Wipro,

---

How to determine the service pack currently installed on SQL Server?

4 Answers   HCL,

---