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
- 6941 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 are the attributes of the cursor?
Can we call a trigger inside a function and function inside a trigger? Give example.
Why oracle is used?
1) Does oracle have any table which contain all the exceptions and it's code internally?
What are the ways tablespaces can be managed and how do they differ?
What is tablespace in oracle? how can we create? how is it manage? . . . Thnx 2 All in Advnc....:)
What query tells you how much space a tablespace named test is taking up, and how much space is remaining?
Respected sir, Please send me technical questions related to oracle apps..
How you find out version of installed workflow?
What is oracle join syntax?
What is snapshot is too old? Give and example for better understand.
Explain the use of parfile option in exp command.
Oracle General 
