s data inserted ? Not Answered
> Paul,
>
> - Original Message -
> From: ""Paul Chu"" <[EMAIL PROTECTED]>
> Newsgroups: mailing.database.myodbc
> Sent: Saturday, June 19, 2004 5:07 AM
> Subject: RE: Clustered Index - Where is data inserted ? Not Answered
Appreciate any help at all
Thanks, Paul
-Original Message-
From: Paul Chu [mailto:[EMAIL PROTECTED]
Sent: Friday, June 18, 2004 10:16 AM
To: [EMAIL PROTECTED]
Subject: Clustered Index - Where is data inserted ?
Hi,
Can someone explain how the data is stored in a table using a
Appreciate any help at all
Thanks, Paul
-Original Message-
From: Paul Chu [mailto:[EMAIL PROTECTED]
Sent: Friday, June 18, 2004 10:16 AM
To: [EMAIL PROTECTED]
Subject: Full Text Index on Large Tables
Hi,
If I have a table with 100 - 200 million rows and I want to search
For
Appreciate any help at all
Thanks, Paul
-Original Message-
From: Paul Chu [mailto:[EMAIL PROTECTED]
Sent: Friday, June 18, 2004 10:16 AM
To: [EMAIL PROTECTED]
Subject: Fastest way to load a master table removing duplicates
Hi all,
I want to load a Master table millions of rows
Hi all,
I want to load a Master table millions of rows for other sources with a
unique index on e.g. ssn social sec number.
If inserted records have a duplicate SSN I don't want to insert those
but put them in a duplicate table or flag them.
.
The primary key will be an auto-increment fiel
Hi,
If I have a table with 100 - 200 million rows and I want to search
For records with specific characteristics.
Ex.
Skills varchar(300)
Skill id's 10 15
Accounting finance etc.
Is it advisable to created a field with skill ids and then use the
Hi,
Can someone explain how the data is stored in a table using a clustered
index.
Does this mean that the data is inserted in the .myd file in sorted
index order ?
If so, how is space made to insert the new records ?
Does this make inserting records slow because data is being inserted in
physi
