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
How to concatenate two strings in SQL Server.
How to add an address record into adventureworkslt?
Please explain go command in sql server?
What is the difference between substr and charindex in the sql server?
What is instead of dml trigger?
What is subquery? Explain the properties of a subquery?
my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions
What do you mean by collation recursive stored procedure?
Explain important index characteristics?
Which are the third-party tools used in sql server and why would you use them?
What do you mean by authentication modes in sql server?
Can I work with several databases simultaneously? : sql server management studio
Mention the different types of replication in sql server.
Explain transaction server auto commit?
Determine how to use the inserted and deleted pseudo tables?