What type of index should you use on a fact table?

Answer Posted / monal

IN SQL SERVER 2005 USING NON CLUSTERED INDEX WOULD BE BETTER.

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

1787


What are the steps you will take to improve performance of a poor performing query?

2658


What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA

785


Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA

807


How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?

2295


Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

1757


When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA

805


What types of replication are supported in sql server? : sql server DBA

1018


how can you initialize log miner?

875


Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

3525


Explain materialized views and how they are used.

2174


Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.

2335


how does an oracle clusterware manage crs resources?

811


what is a user-defined lock?

793


If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA

796