<transcript><audio_127>could do that but no one does that because the primary key uh index is essentially that there have been proposals that talk about doing that because hey does this mean if I have to use this more fancy scheme which is better for performance with the secondary key indices that I must have a</transcript><transcript><audio_128>primary key index the answer is yes the primary key index is typically always built because that's how the system enforces primary key constraint so you can assume especially in that environment you have that so that scheme is basically the preferred scheme to do</transcript><transcript><audio_129>it okay so if you're doing potioning with just about every system does you have to be careful as to what your secondary indices point to all</transcript> could do that but no one does that because the primary key uh index is essentially that there have been proposals that talk about doing that because hey does this mean if I have to use this more fancy scheme which is better for performance with the secondary key indices that I must have a primary key index the answer is yes the primary key index is typically always built because that's how the system enforces primary key constraint so you can assume especially in that environment you have that so that scheme is basically the preferred scheme to do it okay so if you're doing potioning with just about every system does you have to be careful as to what your secondary indices point to all
{"source": "grass-yt-cc-by.-mY8ALcJVTk|shard_1_1|create_multimodal_data.extract_yt_and_generate_transcripts.62|shard_1|create_multimodal_data.generate_captions.62|shard_1|create_multimodal_data.generate_captions.62", "params": {"id": "-mY8ALcJVTk", "channel_id": "UCHnBsf2rH-K7pn09rb3qvkA", "duration": 5000, "view_count": 4483, "age_limit": 0, "like_count": 50, "channel_follower_count": 71100, "license": "Creative Commons Attribution license (reuse allowed)", "uploader_id": "@CMUDatabaseGroup", "yt_tar_file": "/leonardo_work/EUHPC_E03_068/audio/fixed_download/grass-yt-cc-by//shard_1/-mY8ALcJVTk.tar.gz"}}