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
- 8056 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
Give the different types of rollback segments.
What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.
Explain temporal data types in oracle
How to create tables for odbc connection testing?
What is an oracle and why it is used?
What is the exact use of Collections?
How to list all indexes in your schema?
How do I use os authentication with weblogic jdriver for oracle and connection pools?
How to fetch the row which has the max value for a column?
Can you drop an index associated with a unique or primary key constraint?
What is oracle open database communication (odbc)?
types of indexes and the rationale behind choosing a particular index for a situation.
Explain self joins in oracle?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
Why do we use bulk collect in oracle?
