MS SQL Server Indexes Question:
Download Job Interview Questions and Answers PDF
Explain full-text indexing?
Answer:
Full text indexes are stored in the file system and are administered through the database.
Only one full-text index is allowed for one table. They are grouped within the same database in full-text catalogs and are created, managed and dropped using wizards or stored procedures
Only one full-text index is allowed for one table. They are grouped within the same database in full-text catalogs and are created, managed and dropped using wizards or stored procedures
Download SQL Server Indexes Interview Questions And Answers
PDF
| Previous Question | Next Question |
| Do you know what is fill factor and pad index? | Explain what is it unwise to create wide clustered index keys? |