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.
| Author |
Topic |
|
jhun_garma
Starting Member
15 Posts |
 Posted - 2002-02-15 : 00:27:17
|
| let's say you have a static table consisting of 400k records.which is better to use a regular sql index of a full text index ?is there any difference in the perfomance?. Would i benefit in full text index if i don't really need its features (phrased-based search) what are the advantages and disadvantages of both indexes?thanks in advancejhun |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2002-02-15 : 00:43:59
|
| They are completely different. Full text catalogues are (as you suggest) for doing phrased searches of text and the like. It is an efficient way of searching lots of text.Normal Indexes are for every day use. Think of it like the index of a book. If you are looking for a topic in a book, you can go to the index, find it in order, then go to exactly where in the book it occurs. Otherwise, you would need to search each page of the book to find what you were looking for. Essentially, SQL Server indexes work the same way. They are an ordered set of pointers to where the data is stored.You can use indexes in pretty much every query you will write.Books online has lots of good info about indexing.Damian |
 |
|
|
|
|
|
regular SQL indexes vs. Full text indexes