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 |
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
Why would you call update statistics? : sql server DBA
when does an alert gets signaled?
What is a correlated sub-query? : sql server DBA
How can you enable a trace for a session?
You're getting high "busy buffer waits" - how can you find what's causing it?
what is the differnce between process and thread ?
how can you communicate with operating system files from oracle?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
How do you switch from an init.ora file to a spfile?
What is the recommended interval at which to run statspack snapshots, and why?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)