Full Text Search

In my table i need to use Full Text Search on text column
here is my table
==================================
CREATE TABLE [AH_SubMaster] (
[Master_ID] [int] NOT NULL ,
[Fakra_No] [smallint] NOT NULL ,
[Fakra_Text] [text] COLLATE Arabic_BIN NOT NULL ,
[Index_ID] [int] NULL ,
[UserID] [int] NULL ,
[LastModify] [datetime] NULL ,
CONSTRAINT [MyKey_PK_1] PRIMARY KEY CLUSTERED
(
[Master_ID],
[Fakra_No]
) ON [PRIMARY] ,
CONSTRAINT [FK_AH_SubMaster_AH_Master] FOREIGN KEY
(
[Master_ID]
) REFERENCES [AH_Master] (
[ID]
) ON UPDATE CASCADE
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
==================================
When i use Query " Like '%sometext%' " it take long time, so i tried this
==========================
"select Fakra_Text from AH_SubMaster where contains(*,'sometext') "
=============================
but didn't work so how could i fix this search delay without changing my
column data type to varchar coz this is not possible And Can i use full text
search on this table without havinng full text index' and if i can then
How'
any help pleasePlease explain "didn't work". Were there errors? Did you get unexpected or n
o
results?
ML
http://milambda.blogspot.com/|||You need to create a Full-Text index (create a catalogue, add the table and
columns to index) then the CONTAINS and FREETEXT stuff will work.
You can create a Full-Text index through Enterprise Manager (or Management
Studio in 2005).
Best bet is to check the topic out in books online first to make sure you
understand the architecture fundementals first.
Tony
Tony Rogerson
SQL Server MVP
http://sqlserverfaq.com - free video tutorials
"Islamegy" <NULL_Islamegy_NULL@.yahoo.com> wrote in message
news:uUbmOt6CGHA.272@.TK2MSFTNGP10.phx.gbl...
> In my table i need to use Full Text Search on text column
> here is my table
> ==================================
> CREATE TABLE [AH_SubMaster] (
> [Master_ID] [int] NOT NULL ,
> [Fakra_No] [smallint] NOT NULL ,
> [Fakra_Text] [text] COLLATE Arabic_BIN NOT NULL ,
> [Index_ID] [int] NULL ,
> [UserID] [int] NULL ,
> [LastModify] [datetime] NULL ,
> CONSTRAINT [MyKey_PK_1] PRIMARY KEY CLUSTERED
> (
> [Master_ID],
> [Fakra_No]
> ) ON [PRIMARY] ,
> CONSTRAINT [FK_AH_SubMaster_AH_Master] FOREIGN KEY
> (
> [Master_ID]
> ) REFERENCES [AH_Master] (
> [ID]
> ) ON UPDATE CASCADE
> ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
> GO
> ==================================
> When i use Query " Like '%sometext%' " it take long time, so i tried this
> ==========================
> "select Fakra_Text from AH_SubMaster where contains(*,'sometext') "
> =============================
> but didn't work so how could i fix this search delay without changing my
> column data type to varchar coz this is not possible And Can i use full
> text search on this table without havinng full text index' and if i can
> then How'
> any help please
>|||Sorry.. I was mean Like take 1 min 10 Sec and contain take 55 Sec so i don't
see any improvment...
that table that was having the problem have composite keys so it wasn't
allow full text index but i fixed this..
any help in full text search speed'
my database is arabic text
"Tony Rogerson" <tonyrogerson@.sqlserverfaq.com> wrote in message
news:evfYfI7CGHA.312@.TK2MSFTNGP09.phx.gbl...
> You need to create a Full-Text index (create a catalogue, add the table
> and columns to index) then the CONTAINS and FREETEXT stuff will work.
> You can create a Full-Text index through Enterprise Manager (or Management
> Studio in 2005).
> Best bet is to check the topic out in books online first to make sure you
> understand the architecture fundementals first.
> Tony
> --
> Tony Rogerson
> SQL Server MVP
> http://sqlserverfaq.com - free video tutorials
>
> "Islamegy" <NULL_Islamegy_NULL@.yahoo.com> wrote in message
> news:uUbmOt6CGHA.272@.TK2MSFTNGP10.phx.gbl...
>|||Hi, its probably worth posting it to microsoft.public.sqlserver.fulltext and
it will be picked up by somebody with more experience of full-text,
hopefully in non english indexing.
Sorry.
tony.
Tony Rogerson
SQL Server MVP
http://sqlserverfaq.com - free video tutorials
"Islamegy" <NULL_Islamegy_NULL@.yahoo.com> wrote in message
news:uPTypn8CGHA.748@.TK2MSFTNGP12.phx.gbl...
> Sorry.. I was mean Like take 1 min 10 Sec and contain take 55 Sec so i
> don't see any improvment...
> that table that was having the problem have composite keys so it wasn't
> allow full text index but i fixed this..
> any help in full text search speed'
> my database is arabic text
>
> "Tony Rogerson" <tonyrogerson@.sqlserverfaq.com> wrote in message
> news:evfYfI7CGHA.312@.TK2MSFTNGP09.phx.gbl...
>