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
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: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Datataba Concepts, Chapter 5 "Schema Object", section "Overview of Indexes".

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

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


Current Time: Thu Dec 08 19:51:56 CST 2016

Total time taken to generate the page: 0.06992 seconds