What type of index should you use on a fact table?
- 1 Answers
- 3556 Views
- I also Faced
- E-Mail Answers
Answer / monal
IN SQL SERVER 2005 USING NON CLUSTERED INDEX WOULD BE BETTER.
| Is This Answer Correct ? | 3 Yes | 0 No |
What is checkpoint?
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
What is blocking and how would you troubleshoot it?
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.
What is the difference between LMT & DLT?
hi, how can i check all backups are exist to restore? I.e. i forget to take backup on one day. But now i want to check that all backups are there to restore now. I know the answer of through timestamps we know how to check. But i need any other way?
Why would you use sql agent? : sql server DBA
why do we give pctfree and pctused in create table statement?
What is the default fill factor value? : sql server DBA
what is ora 24313?what is the procedure to exclude that error?
How can we know the exact updation date of a particular database?
how can you connect from 10g user to 11g user??
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
