Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Info abt INDEX

Author  Topic 

smousumi
Starting Member

19 Posts

Posted - 2004-03-04 : 05:13:37
Hii,

Can anybody tell me, how indexes makes the transaction faster, what r internally indexes are processed?

I know in the form of B-Tree form.
Then also i am quite confused regardign the internal prcessing, which leads to fastest retrival of records.


Thanks in advance.


mousumi

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-03-04 : 12:36:55
Do you have any good SQL Server books or any database books? This topic is too lengthy to discuss in a forum. I suggest reading the Inside SQL Server book for this kind of information.

Tara
Go to Top of Page
   

- Advertisement -