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
- 7374 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 |
Explain the use of online redo log files in oracle.
14. Display the item_cost and then round it to the nearest hundred, ten, unit, tenth and hundredth
you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz
Query to get max and second max in oracle in one query ?
34 Answers CTS, Keane India Ltd, TCS, Wipro,
Can we commit inside a function in oracle?
What is the difference between count (*), count (expression), count (distinct expression)?
How to assign query results to variables?
What operating systems are supported by oracle database 10g xe?
Name the three major set of files on disk that compose a database in Oracle?
How to get last row id?
How to set up autotrace for a user account?
How to use "in out" parameter properly?
Oracle General 
