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: 64956
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: 3727
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: Mon Jun 26 14:18:07 CDT 2017

Total time taken to generate the page: 0.04637 seconds