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
Do you know clustered and non-clustered index?
What is an inner join?
What do you understand by triggers?
Explain system rowset functions?
What is sql server programming?
How to achieve Paging of records in SQL SERVER?
Explain sql server authentication modes?
How many types of cursor type are there?
Is foreign key unique?
If we delete pack Spec what will be the status of pack Body ?
What is table-valued sub query?
Explain table valued parameters in sql server? Why tvp used?
What is difference between rownum and row_number?
How many clustered indexes there can be on table ?
What are the steps to follow to configure SQL*Net?