We create an index to fast the search. How it fast the query? Do we write any

We create an index to fast the search. How it fast the
query? Do we write any special keyword with query?

Question Posted / vinod

3 Answers
4631 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

We create an index to fast the search. How it fast the query? Do we write any special keyword with..

Answer / ish

It is depend on which type of indexing u r using .
clustered or non clustered.

if u r searching one record then used nonclustered indexing.
if u r searching bulk of record then used clustered indexing

Is This Answer Correct ?

3 Yes

0 No

We create an index to fast the search. How it fast the query? Do we write any special keyword with..

Answer / laxman

we need to use indexed column in where clause

Is This Answer Correct ?

1 Yes

0 No

We create an index to fast the search. How it fast the query? Do we write any special keyword with..

Answer / nixo

In the case search is the query. How would you search in
the database? I think you will use sql query.

Is This Answer Correct ?

0 Yes

1 No

Post New Answer