what is the difference between oracle indexes and sql server indexes?

0 ⤊

what is the difference between oracle indexes and sql server indexes?

2006-10-11 10:21:39 · 3 answers · asked by bhardwaja t 1 in Education & Reference ➔ Other - Education

3 answers

By Definition : An index is a performance-tuning method of allowing faster retrieval of records. An index creates an entry for each value that appears in the indexed columns.
This is common for both Oracle and SQL Server
By default, Oracle creates B-tree indexes.

If u wanna know how it is stored internally, try google with "Oracle" Index and "SQL Server" Index. Check the following links.

2006-10-11 18:07:18 · answer #1 · answered by Subhasis G 4 · 0⤊ 0⤋

Can you be little more specific about what you actually want to know?

2006-10-11 12:32:12 · answer #2 · answered by Anonymous · 0⤊ 0⤋

specify in which aspect?

2006-10-11 12:34:25 · answer #3 · answered by abcdefg 5 · 0⤊ 0⤋