Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me

4356


Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1915


what is a crs resource?

1173


how can you communicate with operating system files from oracle?

1056


Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA

1088


Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

2349


what is the last version,the release date of that version and fix pack of ibm db2 udb?

1978


what do you understand by fine-grained auditing?

1065


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

3767


You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

4434


You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

2821


What the different components in replication and what is their use? : sql server DBA

1057


how can you connect from 10g user to 11g user??

2118


suppose you want to audit specific activities on sensitive data. How can you achieve that?

1006


What the different types of replication and why are they used? : sql server DBA

1180