1. How can i enforce to use particular index?
2. What is sorting and what is the difference between sorting and clustered indexes?
3. What is a table called, if it does not have neither Cluster nor Non-cluster Index? What is it used for?
4. How to know which index a table is using?
5. Size of Clustered and Non-Clustered in 2005 and 2008?
6. What do you mean by Filtered indexes?
7. What is heap table in SQL SERVER?
8. What are the difference between clustered and a non-clustered index?
9. What are the different index configurations a table can have?
10. What are the trade offs with having indexes?
11. What types of index data structures can you have?
12. What is "index covering" of a query?
13. What is Index?
14. Can we create primary key without clustered index?
15. What is UPDATE_STATISTICS command?
16. What will be the maximum number of index per table?
17. What is an index? What are the types of indexes? 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?
18. What are statistics, under what circumstances they go out of date, how do you update them?
19. When a query is sent to the database and an index is not being used, what type of execution is taking place?
20. What are Index Optimization tips?
21. What is Index? It's purpose?
22. Explain about Clustered and non clustered index? How to choose between a Xlustered Index and a Non-Clustered Index?
23. Disadvantage of Index?
24. Give a scenario that i have a 10 clustered index in a table to all their 10 columns. What are the advantages and disadvantages?
25. How can i enforce to use particular index?
26. What is index tuning?
27. Differences between index defrag and index rebuild?
28. What is sorting and what is the difference between sorting & clustered indexes?
29. What are statistics, under what circumstances they go out of date, how do you update them?
30. What is fill factor? What is the use of it? What happens when we ignore it ? When you should use low fill factor?
31. How many type of indexes are there?
32. How many index can be created on a table?
33. What is Filtered Index in SQL?
34. Create INDEX mu Index ON myTable ( myColumn )
What type of Index will get created after executing the above statement?
2. What is sorting and what is the difference between sorting and clustered indexes?
3. What is a table called, if it does not have neither Cluster nor Non-cluster Index? What is it used for?
4. How to know which index a table is using?
5. Size of Clustered and Non-Clustered in 2005 and 2008?
6. What do you mean by Filtered indexes?
7. What is heap table in SQL SERVER?
8. What are the difference between clustered and a non-clustered index?
9. What are the different index configurations a table can have?
10. What are the trade offs with having indexes?
11. What types of index data structures can you have?
12. What is "index covering" of a query?
13. What is Index?
14. Can we create primary key without clustered index?
15. What is UPDATE_STATISTICS command?
16. What will be the maximum number of index per table?
17. What is an index? What are the types of indexes? 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?
18. What are statistics, under what circumstances they go out of date, how do you update them?
19. When a query is sent to the database and an index is not being used, what type of execution is taking place?
20. What are Index Optimization tips?
21. What is Index? It's purpose?
22. Explain about Clustered and non clustered index? How to choose between a Xlustered Index and a Non-Clustered Index?
23. Disadvantage of Index?
24. Give a scenario that i have a 10 clustered index in a table to all their 10 columns. What are the advantages and disadvantages?
25. How can i enforce to use particular index?
26. What is index tuning?
27. Differences between index defrag and index rebuild?
28. What is sorting and what is the difference between sorting & clustered indexes?
29. What are statistics, under what circumstances they go out of date, how do you update them?
30. What is fill factor? What is the use of it? What happens when we ignore it ? When you should use low fill factor?
31. How many type of indexes are there?
32. How many index can be created on a table?
33. What is Filtered Index in SQL?
34. Create INDEX mu Index ON myTable ( myColumn )
What type of Index will get created after executing the above statement?
No comments:
Post a Comment