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



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

Post New Answer

More DB Administration Interview Questions

What questions might be they ask in managerial round in capgemini.

1 Answers   Cap Gemini, iGate,


Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

0 Answers  


How do you open a cluster administrator? : sql server DBA

0 Answers  


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

0 Answers  


what are the differences of where and if in SAS?

0 Answers  






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

1 Answers  


wat is global index and local indes

1 Answers   Oracle,


How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?

0 Answers   EDS,


I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB

0 Answers  


What is blocking and how would you troubleshoot it?

1 Answers  


What are the different types of upgrades that can be performed in sql server? : sql server DBA

0 Answers  


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.

0 Answers  


Categories