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

how can you schedule a job in database?

828


Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com

1919


what is ora 24313?what is the procedure to exclude that error?

2341


Why does Oracle not permit the use of PCTUSED with indexes?

2614


What are the different ways you can create databases in sql server? : sql server DBA

825


what are the performance views in an oracle rac environment?

816


What is the difference between the 2 operating modes of database mirroring? : sql server DBA

752


what do you understand by flashback feature of oracle?

790


List out some of the requirements to setup a sql server failover cluster.? : sql server DBA

917


What is dbcc? : sql server DBA

997


What purpose does the model database server? : sql server DBA

842


what is the role of dip user in our database?

2233


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

922


when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.

1448


What is the default fill factor value? : sql server DBA

825