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 |
|
pcs001
Starting Member
6 Posts |
 Posted - 2010-08-01 : 12:02:13
|
| I am executing a query on a large table and it is taking forever (if not frozen up). I did a full-text index table and it said that the table was not indexed. So I use the "create index" command, run it on a smaller table and it said that the table was indexed successfully, but when I tried the full-text index table function on the small table (just indexed), it still says table not indexed. Can anyone tell me what is wrong here? Thanks in advance. |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-08-01 : 15:11:02
|
| Full text indexes and nonclustered indexes (CREATE INDEX) are totally different things. I suggest that you read up on both in Books Online and see what the two are used for.Now, what's the query that you want optimised, what's the defintions of the tables and what indexes do you have?--Gail ShawSQL Server MVP |
 |
|
|
pcs001
Starting Member
6 Posts |
Posted - 2010-08-01 : 19:46:05
|
| It's simple select/where query although the table is 9GB in size that it was taking more than 4.5 hours for me to do 'create index' on that table. Now that it is created, that is the only index that I have for it. It has about 10 columns and 1.1+ million rows.c |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-08-02 : 05:49:53
|
| Good to know. You still have a question on this?--Gail ShawSQL Server MVP |
|
|
|
|
|
|
Table running slow - need index