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
- 7134 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
What are the uses of synonyms?
How do I know if oracle client is installed on windows?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
Explain oracle’s server parameter file.
State any two functions of oracle?
How to update a table row with a record?
how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?
How to shutdown your 10g xe server?
Give syntax for SQL and ORACLE joins.
What are advantages of dateset in datastage?
How many types of database triggers exist?
How to call a stored function with parameters?
How to create a new oracle data file?
Describe varray?
What are the execution control statements in oracle?
