1. Categories >> Software >> Databases >> DB Administration
  2. Suggest New Category

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

Post New Answer

More DB Administration Interview Questions

how do see how much space is used and free in a tablespace

2 Answers   Genpact,

You have just compiled a PL/SQL package but got errors, how would you view the errors?

3 Answers  

How do you tell what your machine name is and what is its IP address?

4 Answers  

What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?

2 Answers  

what is rebuild index??

2 Answers   IBM, Sapient,




From the database level, how can you tell under which time zone a database is operating?

1 Answers  

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

0 Answers  

what is the use of ocr?

0 Answers   Oracle,

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

0 Answers  

I lost one datafile i dont have backup how can you recover that???

2 Answers   HP,

how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?

0 Answers   HSBC,

How do you troubleshoot errors in a sql server agent job? : sql server DBA

0 Answers  

For more DB Administration Interview Questions Click Here
Categories