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

Question Posted / guest

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

Answer / monal

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

Is This Answer Correct ?

3 Yes

0 No

More DB Administration Interview Questions

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

what is the difference between hot backup n rman backup?

Which environment variables are absolutely critical in order to run the OUI?

What view(s) do you use to associate a user's SQLPLUS session with his o/s process?

In what script is "snap$" created? In what script is the "scott/tiger" schema created?

How do you trace the traffic hitting a sql server? : sql server DBA

How will u copy the objects of one schema to another schema in datapump & export/import?

Should you place Recovery Catalog in the Same DB? . Can you use RMAN without Recovery catalog

Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

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

Can we take incremental backups in datapump?

What are the operating modes in which database mirroring runs? : sql server DBA

For more DB Administration Interview Questions Click Here