Answer Posted / guest
When queries are run against a db, an index on that db
basically helps in the way the data is sorted to process the
query for faster and data retrievals are much faster when we
have an index.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to concatenate two character strings together?
Give a example to search fr a string in all stored procedure in sql server.
What is the use of builtinadministrators group in sql server? : sql server security
How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?
What is difference between count (*) and count 1?
What is identity?
How to create prepared statements using odbc_prepare()?
Do you know what is bit data type and whats the information that can be stored inside a bit column?
What is sharding?
What is user-defined inline table-valued function?
Explain the difference between clustered and non-clustered index?
Explain what is the main purpose of having conversation group?
How many replicas are maintained for each SQL Azure database?
Can primary key be a foreign key?
How to convert numeric expression data types using the cast() function?