We create an index to fast the search. How it fast the
query? Do we write any special keyword with query?
Answer Posted / 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 |
Post New Answer View All Answers
What does <> symbol mean?
Mention the different authentication modes in sql server.
What is store procedure? How do they work?
What is the new security features added in sql server 2016? : sql server security
How to return the date part only from a sql server datetime datatype?
How to replace null values in expressions using isnull()?
Tell me about normalization in DBMS.
How do I create a stored procedure in sql server?
How do I find query history in sql server?
what is database replication? : Sql server database administration
What are tables in sql server?
What is the full meaning of dml?
Explain system scalar functions?
Write a program to fetch first 10 records from a file?
What the different components of Replication and what is their use?