Home » RDBMS Server » Performance Tuning » Regarding Index
Regarding Index [message #232348] Fri, 20 April 2007 04:17 Go to next message
shahnazurs
Messages: 240
Registered: June 2005
Location: India
Senior Member
Hi,
Correct me if i am wrong.

Whenever we create an index on a particular column without giving type of index that will become BTree index.

Can we give any type for BTree index?

Please explain me how BTree index works with an example.

Thanks,
Shahnaz

Report message to a moderator

Re: Regarding Index [message #232368 is a reply to message #232348] Fri, 20 April 2007 05:34 Go to previous messageGo to next message
Michel Cadot
Messages: 68704
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Datataba Concepts, Chapter 5 "Schema Object", section "Overview of Indexes".

Regards
Michel

Report message to a moderator

Re: Regarding Index [message #232377 is a reply to message #232368] Fri, 20 April 2007 06:14 Go to previous message
rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia
Senior Member
This may also help.
Ross Leishman

Report message to a moderator

Previous Topic: faq's in perfomance tuning
Next Topic: slow and freezed
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Nov 04 15:29:49 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.