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
- 7825 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / surendra
we can create number of indexes we want but these are useful to us to speed up the retreive the records
such as these columns are simultaneously used in where clause
when we create more indexes that are not necessary to us at that time the performance is definitely decreased.
so, create indexes depends upon the usage.
| Is This Answer Correct ? | 4 Yes | 3 No |
What is a package in oracle?
Whats the benefit of dbms_stats over analyze?
What should be the return type for a cursor variable.Can we use a scalar data type as return type?
What is max rowid in oracle?
How to export your own schema?
In Oracle 9i what does "i" Stands for?
How to use select statement to count the number of rows in oracle?
why you need store procedure ? where do we use it in a Java project? can you get the code for as store procedure using in Java?
What are the basic element of Base configuration of an oracle Database ?
what is the difference between rollback & commit? can a foreign key has null value?
I have table-A(1,2,3,4,4,5,6,6,6,7). how to get all duplicate values?what is sql query?
How to rename a column in an existing table?
Oracle General 
