Interested to Buy Any Domain ? << Click Here >> for more details...
what is the maximum number of indexes i can create for a
table?
What happens if i create indexes for all the columns of a
table? Will it slow down the speed of retrieval
- 2 Answers
- 7856 Views
- I also Faced
- E-Mail Answers
Answer Posted / nawazish sultan
In sql server 2005 we create 250 indexes (1 clustered + 249
non clustered) where as in sql server 2008 it 999.
It is not a best practice to create indexes on all the
columns.Create index on whichever it is necessary becoz it
wont affect too much on DRL but it will obviously slowdown
the DML operation.
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
is there a tool to trace queries, like profiler for sql server?
In the oracle version 9.3.0.5.0, what does each number shows?
How to export data with a field delimiter?
Can we connect to ORACLE db using Windows Authentication?
Can we insert data in view oracle?
How to run queries on external tables?
Explain the use of control file?
Explain an extent?
What is a dead lock in oracle?
Explain an integrity constrains?
What is an oracle recycle bin?
Explain what does a control file contain?
Is rowid unique in oracle?
How to execute a stored program unit?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
