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
- 6944 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 |
How to create a temporary table in oracle?
What is the data type of dual table?
waht is referencial integrity?
How to get a list of all user accounts in the database?
ex. one table is having 1 column with 10 records , then how to display all the values in row wise ?
What is OCI. What are its uses?
SELECT THE RECORDS FROM 3 TABLES LIKE(T1,T2,T3) AND HOW CAN WE INSERT THAT RECORD IN ANOTHER TABLE LIKE(T4)?
State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.
how many outer joins are used in a single sql query? is there any limitations for using of outer joins?
2 Answers BOB Technologies, Cap Gemini, IBM,
What is hot backup and logical backup?
How to create a new oracle data file?
Define Transaction ?
Oracle General 
