StrataFrame Forum
Back
Login
Login
Home
»
StrataFrame Database Deployment Toolkit
»
Database Deployment Toolkit (How do I?)
»
Turning off default PK Clustered index
Turning off default PK Clustered index
Post Reply
Like
1
Turning off default PK Clustered index
View
Flat Ascending
Flat Descending
Threaded
Options
Subscribe to topic
Print This Topic
RSS Feed
Goto Topics Forum
Author
Message
Charles R Hankey
Charles R Hankey
posted 18 Years Ago
ANSWER
HOT
Topic Details
Share Topic
Group: Forum Members
Posts: 524,
Visits: 30K
I see that my new best friend - the DDT - creates PK indexes as clustered.
Is there a good way to turn this off, either globally ( in source code ? ) or perhaps there is something I'm missing in the current interface ( writing this before installing 1.61 so if it's there already just point me to it )
I use a lot of UID PKs in tables I am converting from VFP and my understanding is a clustered index isn't a good idea.
TIA
Charles
Reply
Like
1
Reply
Trent Taylor
Trent Taylor
posted 18 Years Ago
ANSWER
Post Details
Share Post
Group: StrataFrame Developers
Posts: 6.6K,
Visits: 7K
Yeah...you got it figured out! I am glad that you are enjoying it...we like it pretty good too
Reply
Like
1
GO
Merge Selected
Merge into selected topic...
Merge into merge target...
Merge into a specific topic ID...
Open Merge
Threaded View
Threaded View
Turning off default PK Clustered index
Charles R Hankey
-
18 Years Ago
Of course you guys are way ahead of me. Don't know if it was there in...
Charles R Hankey
-
18 Years Ago
Yeah...you got it figured out! I am glad that you are enjoying it...we...
Trent L. Taylor
-
18 Years Ago
Where did you hear that clustered indexes were bad? and what was the...
Keith Chisarik
-
18 Years Ago
Found it, clustered indexes are bad for GUID's, like you said because...
Keith Chisarik
-
18 Years Ago
The problem with clustered indexes in a GUID field are that the GUIDs...
StrataFrame Team
-
18 Years Ago
I kind of geeked out on this one as GUIDs are such a part of my VFP...
Charles R Hankey
-
18 Years Ago
Yes, using the NewSequentialID() method is awesome, but if you want to...
StrataFrame Team
-
18 Years Ago
Actually, I don't want the server to assign the values. My goal would...
Charles R Hankey
-
18 Years Ago
Charles, I am using guids as primekeys as well. I don't think...
Paul Chase
-
18 Years Ago
Yep, Paul is right... Just override the OnSetDefaultValues() method...
StrataFrame Team
-
18 Years Ago
Awesome Ben Iknew the property descriptor was there but didn't think...
Paul Chase
-
18 Years Ago
You guys are terrific. I'm really glad I asked about this. Clustered...
Charles R Hankey
-
18 Years Ago
Post Reply
Like
1
Similar Topics
Post Quoted Reply
Reading This Topic
Login
Login
Remember Me
Reset Password
Resend Validation Email
Login
Explore
Messages
Mentions
Search